|
|
Sum based on specific condition by
Wendy
Need help...I am trying to sum only those values in column (D)
whose corresponding value in column (A) is greater than the value in
column (B).
(A) ...
( 1 2 3 ... Last Page)
|
|
43 |
1,635 |
|
|
Calculating age from birth dates by
John Nall
I need help with a similar problem. I am making a spreadsheet with the
names, DOB, and DOD dates for persons in a church cemetery. I am having
trouble with...
|
|
2 |
1,624 |
|
|
Counting question by
John
In column A I have set of characters that are entered into the rows below
(i.e. Y, N, MRO) in column B I have another set of characters that are
entered into...
( 1 2)
|
|
16 |
1,619 |
|
|
Excel Formula Help please by
Seventh Day is The Sabbath
Please Help, I am trying to make a formula which you may think is simple,
but my old head finds it hard, I am trying in excel to change a
corresponding time in...
|
|
3 |
1,596 |
|
|
|
|
20 |
1,596 |
|
|
Don't show Zeros by
Morpheseus
I know I've seen this somewhere but I cannot find it. I looked all day with
no luck. I have to ask what I know is a simple question :(
I did up an invoice. ...
|
|
2 |
1,595 |
|
|
Excel 2003: RAND and RANDBETWEEN functions by
Rita Nikas [MSFT]
Hi all.
I just wanted to give you some information on this concern direct from
Microsoft. In addition, this problem was mentioned in Woody's Watch, and...
( 1 2 3)
|
|
20 |
1,578 |
|
|
|
May 13th, 2004 07:45 PM
by
|
0 |
1,576 |
|
|
|
|
4 |
1,571 |
|
|
Drop Down Lists 2007 by
tlynn
I have followed all the steps in creating a drop down list in Excel 2007:
Created Named list on seperate sheet
goto the sheet that the drop down will be on...
( 1 2)
|
June 2nd, 2010 01:19 PM
by Max
|
10 |
1,554 |
|
|
|
|
6 |
1,549 |
|
|
IF STATEMENT by
sbain
I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01)
First off, the statement does not seem to evaluate the "roundup" part,
meaning that...
( 1 2)
|
|
19 |
1,546 |
|
|
Merging Columns by
Titanium
I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is...
( 1 2)
|
May 31st, 2010 09:36 PM
by vhnbvb
|
13 |
1,546 |
|
|
EXCEL 2002 INVOICE TEMPLATE by
BRIAN
IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND
THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX
FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...
|
|
2 |
1,540 |
|
|
Formula checking multiple worksheets by
sonic-the-mouse
I have been tasked with streamlining a spreadsheet used at work. It previously had 28 worksheets
A sheet for each month of the year to list occurences
An audit...
( 1 2)
|
June 6th, 2005 06:37 PM
by Biff
|
11 |
1,522 |
|
|
Calculating a rolling calendar year by
Dana
I am trying to keep track of employee attendance (small
company - under 50 people) in Excel. I have created a
workbook that has a sheet for each employee. In...
|
March 4th, 2004 11:25 PM
by
|
2 |
1,509 |
|
|
xdate in Windows 7 by
Help with scheduling issue
I finally entered the world of Windows 7, albeit only because my laptop died.
I am a historan who needs to calculate dates into the 18th century. Xdate...
|
|
2 |
1,490 |
|
|
|
|
1 |
1,484 |
|
|
copying a formula down wards by
UKMAN
=INDEX(Proj_code,MATCH(AQ$6,F$7:F$198,0))
the above formula works in that it shows the first match.
As there could be mulitpule records what do I need to do...
( 1 2)
|
|
10 |
1,473 |
|
|
|
|
3 |
1,457 |