Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I count If for these special distinctions
I need to count the number of names in a very long list
complaring excel columns that are titles name and date. I would like the formula to count all DISTINCT names on EACH given date giving me a grand total of names. EXAMPLE James Smith June 12, 2004 James Smith June 12, 2004 Mike Black June 12, 2004 Karen Jones June 13, 2004 Mike Black June 13, 2004 Jane Smith June 13, 2004 Total Count: 5 I appreciate the help. Thank you. |
#2
|
|||
|
|||
I don't quite understand your explanation of where the date comes into the
picture, but this formula will count unique entries in Column A: =SUMPRODUCT((A1:A300<"")/COUNTIF(A1:A300,A1:A300&"")) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Desperate Novice" wrote in message ... I need to count the number of names in a very long list complaring excel columns that are titles name and date. I would like the formula to count all DISTINCT names on EACH given date giving me a grand total of names. EXAMPLE James Smith June 12, 2004 James Smith June 12, 2004 Mike Black June 12, 2004 Karen Jones June 13, 2004 Mike Black June 13, 2004 Jane Smith June 13, 2004 Total Count: 5 I appreciate the help. Thank you. |
#3
|
|||
|
|||
Check out Chip Pearson's formulas for counting unique items.
http://www.cpearson.com/excel/duplic...CountingUnique Gord Dibben Excel MVP On Mon, 24 Jan 2005 12:41:08 -0800, "Desperate Novice" wrote: I need to count the number of names in a very long list complaring excel columns that are titles name and date. I would like the formula to count all DISTINCT names on EACH given date giving me a grand total of names. EXAMPLE James Smith June 12, 2004 James Smith June 12, 2004 Mike Black June 12, 2004 Karen Jones June 13, 2004 Mike Black June 13, 2004 Jane Smith June 13, 2004 Total Count: 5 I appreciate the help. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter and count | Excel Discussion (Misc queries) | |||
Count occurences between dates | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |