|
|
|
|
19 |
125 |
|
|
If Statement by
ppidgursky
I am looking to add more items to a IF statement. The current is:=IF('Week
2'!$E$20="Annual","A",IF('Week 2'!$E$20="Sick","S",IF('Week...
( 1 2)
|
|
19 |
167 |
|
|
Best 25 scores..help please by
Terry
Hi group
Win XP
MS Office 2003
I use a spreadsheet to record players bowls drives scores, and wish to flag
up the best 25 scores for each player, from the...
( 1 2)
|
February 15th, 2008 02:45 PM
by Terry
|
19 |
153 |
|
|
OLD PROBLEM without SOLUTION by
ytayta555
A good day !
I have this function :
=AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E5)=1;COUNT(F1;F3;F5)=1) ;
this function...
( 1 2)
|
|
19 |
166 |
|
|
Countifs with same reference? by
CEBeau
I am attempting to create age ranges using the COUNTIFS formula. However,
the numbers that is gives back to me are wrong.
The formula:...
( 1 2)
|
|
19 |
184 |
|
|
Special Paste confusion by
Nobody
I have been told to use Special Paste, here is what I have been told
The paste special command is a very
useful command which you should add to your...
( 1 2)
|
October 18th, 2008 04:56 AM
by Nobody
|
19 |
415 |
|
|
|
|
19 |
308 |
|
|
extract date from text by
Woodi2
I have the following text string in cell A1. Flight Schedule - Friday 28th
November 2008.
How can I extract the date from the text string and paste it in...
( 1 2)
|
|
19 |
131 |
|
|
Extracting h:mm:ss from text string by
Micki
I have raw data that downloads in 2 different formats.
451 22:07:34 (451 = # days a problem is not resolved)
3:39:10 (hrs, minutes, seconds)
I need a formula...
( 1 2)
|
|
19 |
124 |
|
|
table formula by
jeel
I would like to create a table that is 16 rows deep and 16 columns across
where the
numbers 1:16 are in the cells in column a. Then going across I need each...
( 1 2)
|
February 16th, 2008 05:10 AM
by jeel
|
19 |
143 |
|
|
|
|
19 |
167 |
|
|
excel formulas by
Tomas
How would I do the following:
A+B = C,
if C = 10 then D = 1
if C = 11 then D = 2
C = 12 then D = 3
and so on
C = 19 then D = 1
thank...
( 1 2)
|
February 20th, 2008 03:01 PM
by ELOGEE
|
19 |
324 |
|
|
|
|
19 |
181 |
|
|
Counting unique items based on date by
DKS
I have a sheet, with each row containing one record. Column A contains a
date, and column B contains a department. The contents of the column A
(date) are...
( 1 2)
|
|
19 |
113 |
|
|
|
|
19 |
207 |
|
|
|
|
19 |
119 |
|
|
|
|
18 |
581 |
|
|
|
|
18 |
499 |
|
|
Sumproduct clarification by
Walter Mayes
Various members of this forum have stated that the arrays used in
SUMPRODUCT must be the same.
Excel HELP says, under remarks, in part..."Array arguments must...
( 1 2)
|
|
18 |
442 |
|
|
Empty Cells, COUNTBLANK, and ISBLANK by
Jim Watkins
Both COUNTBLANK and ISBLANK relate to empty cells. Yet I
have a spread sheet that provides the following seemingly
contradictory results:
* The calculated...
( 1 2)
|
|
18 |
656 |