A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
Searching for the nearest value by Abidan
I have created a spreadsheet containing several rows and columns each with a numerical value to 3 decimal places. The values in each cell correspond to...
August 9th, 2006 06:11 PM
by Ian Go to last post
1 233
Enquiry Form by Abidan
I would appreciate some guidance as to the best way to create an enquiry form linked to a database for my sales dept. to enable them to enter customer...
August 15th, 2006 11:35 AM
by Abidan Go to last post
0 42
how do i convert numbers (25) into words (Twenty Five Only) ... by Abidhsz
hi, i need a formula in excel to convert numbers into words spose i type 25,000 in a cell it should be convert into words in other selected cell. 25,000...
March 19th, 2007 03:02 PM
by David Biddulph Go to last post
1 54
To leave a cell blank following an "IF" function by abie26
How can I leave a cell blank following a response to an "IF" function? Because in Excel 2007, the default response in a cell is "FALSE" when I leave a cell...
April 11th, 2007 09:44 PM
by abie26 Go to last post
9 143
linking cell colors by abielo
How can I link the color in one cell to the color in another cell? Thanks in advance.
August 17th, 2006 06:16 AM
by Max Go to last post
3 58
Logic Statement by abierly
Hello. I'm trying to have one cell look at two other cells to determine its entry. This what I'm stuck on: =If(E4=1 and E7=1, 60, if(E4=1 and E7=2, 50,...
March 14th, 2006 07:13 PM
by Ron Rosenfeld Go to last post
3 145
Multiple pivot tables by [email protected]
Hi is there anyway that I can combine separate pivot tables onto the same sheet. I have tried to create a pivot table in the same sheet as another one I have...
April 19th, 2008 05:35 PM
by Debra Dalgleish Go to last post
2 80
convert number to english text. example: 2=two, 100=hundred by abiot
I am a civil engineer working in 40,000,000 dollar road construction project in ethiopia. And I am a quantity surveyor. after calculating payments in excel,...
December 16th, 2008 08:45 AM
by Ron@Buy Go to last post
2 99
Macros vs. VBA by Abir
Is this the right place to ask abo
October 3rd, 2003 04:57 AM
by Dennis Go to last post
1 118
Multi-sheet issue by Abir
I have several sheets of budget numbers that are linking from one sheet to another. In linking several sheets by pulling totals from one sheet to create other...
October 3rd, 2003 05:05 AM
by Abir Go to last post
2 82
auto populate different cells when selecting from drop down list. by abitanga
Help, can someone point me in the correct direction for this info! What I am trying to do is program a Excel spreadsheet to auto populate several different...
February 21st, 2009 12:44 AM
by Ashish Mathur[_2_] Go to last post
2 77
comparing data in different columns or worksheets by abizar
try matching only the 13 characters in both columns, by modifying the original data with the Left (a, 13) command, before the vlookup. -----Original...
October 8th, 2003 12:56 PM
by FDDavis Go to last post
1 398
How to get a blank cell instead of a "0" by ABlevins
I used (various and many) spreadsheets at www.contextures.com to create a 2-tier dependent drop-list for addressing invoices. The third, fourth, and fifth...
April 8th, 2008 10:46 PM
by Dave Peterson Go to last post
2 95
Dependent DropLists - Using Validation by ABlevins
I am trying to use dependent droplists to input addresses on invoices. I need to create a series of five dependent lists. There are a total of 68 items in...
April 7th, 2008 03:57 PM
by ryguy7272 Go to last post
1 89
Piviot Table Setup by ABN
Hi, I have a piviot table setup with the information below. Count of Incidents, by year, by month, by system, by problem type (request) What I am trying to...
August 4th, 2004 06:31 PM
by ABN Go to last post
0 138
count the no of specific position by aboiy
Hi, Our company have more than 900 workers with approx. 35 different position. I need to count the total no. of each respective position that attended the...
January 22nd, 2004 11:58 AM
by Norman Harker Go to last post
4 282
Sort dates dd.mm.yy by year by aboiy
Hi Hayley, Try also this tips i got from the groups before; You'll need a helper column. with your dates in column A put the formula in column B, C, D. A ...
January 28th, 2004 01:28 AM
by 2rrs Go to last post
3 280
computing numeric with text by aboiy
Can you help me make a formula for column c without separating the text? Everyday were receiving report with this kind of formatting, it would be time...
(Multi-page thread 1 2)
May 4th, 2004 09:18 PM
by Aboiy Go to last post
10 150
formula for balance & over expense amount by aboiy
Hi, I have this spreadsheet for our daily expenses Sheet 1 (Budget & Cost Center) col. A B C No. Acct. Budget 1- 360 4,600 2- 280 ...
May 5th, 2004 07:03 PM
by Aboiy Go to last post
5 381
count the production result and making the date in text format by aboiy
I have this calculation sheet based on the work production of our personnel, i just want to know the following : Month: October, 2003 A B C ...
October 25th, 2003 08:24 AM
by Go to last post
5 457
Post New Thread


Display Options
Showing threads 961 to 980 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.