|
|
REPORTING unique values by
jane
here is my data:
Mary
Sally
Sally
Mary
John
John
David
I used the following to COUNT the unique values:
( 1 2 3)
|
|
26 |
421 |
|
|
if formula #value by
dan dungan
Hi,
In Excel 2000, I'm converting a company's part number to our part
number.
Company part number with band
440HS030NF2107-3B
440HS030NF2107-3K
our part...
( 1 2 3)
|
|
26 |
341 |
|
|
|
|
26 |
239 |
|
|
|
|
26 |
225 |
|
|
|
September 13th, 2009 07:26 PM
by Bernd P
|
25 |
331 |
|
|
|
|
25 |
191 |
|
|
Name - relative reference doesn't calculate by
Werner Rohrmoser
Hi,
I use a mane with a relative reference to sum 3 cells to the left or
in another case
the 3rd, 6th, 9th and 12th cell to the left.
The syntax for the name...
( 1 2 3)
|
January 29th, 2008 01:45 PM
by Lori
|
25 |
291 |
|
|
|
|
25 |
239 |
|
|
|
|
25 |
196 |
|
|
Countif funtion by
Dot
I'm trying to bring three columns together that checks for a condition of a
persons name and counts how many items were processed. I have the first
function...
( 1 2 3)
|
November 16th, 2008 06:43 PM
by T. Valko
|
25 |
206 |
|
|
Sumproduct issues by
SteveDB1
Hi folks.
I use sumproduct to sum columns of values after testing against 2 criteria.
At first it was working great, and then it stopped working once one cell...
( 1 2 3)
|
|
25 |
200 |
|
|
Sumproduct Help by
Biff
Hi Sandy,
As an alternative to Normans fine reply:
=SUMPRODUCT((A1:A7={"CAT","FISH"})*B1:B7)
Biff
-----Original Message-----
A B
( 1 2 3)
|
April 16th, 2004 01:05 AM
by gilbert
|
25 |
308 |
|
|
|
|
25 |
1,079 |
|
|
Is it possible? by
DakotaNJ
I have a workbook with several tabs. The top tab is the main spreadsheet
were I enter all my gathered data. The other tabs are the same spreadsheet,
the same...
( 1 2 3)
|
|
25 |
719 |
|
|
|
July 6th, 2006 08:40 AM
by Max
|
24 |
281 |
|
|
Combin by
Andreas
If I use =Combin(40,6) I get the result 3838380.
I would like to know which combination the numbers 3,12,17,24,32,36
represent without having to create all...
( 1 2 3)
|
July 25th, 2006 05:59 AM
by Max
|
24 |
240 |
|
|
To Fran Kabel by
LEB
Sorry. I lost track of the thread in which I asked the
question about dashes in a SUMPRODUCT function.
You responded the dashes forced Boolean values...
( 1 2 3)
|
March 22nd, 2004 11:46 AM
by Russ
|
24 |
265 |
|
|
how do I email amacro? by
leo
I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx
( 1 2 3)
|
August 9th, 2006 02:47 PM
by leo
|
24 |
211 |
|
|
Formula needed by
Bob Vance
--
If B2 0 "OVERDUE" 0 "CREDIT" But If B1 = B3 " VERY OVERDUE"
Thanks in advance for your help....Bob Vance
( 1 2 3)
|
|
24 |
283 |
|
|
Replace =RAND() with =ABS(RAND()) by
Don
I recommend you change every instance of =RAND() in your spreadsheets with =ABS(RAND()) as Excell 2003 gives values of =RAND() from -1 to +1.
Unless you want...
( 1 2 3)
|
|
24 |
489 |