| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count unique names in a list
hi
How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count unique names in a list
One way...
=SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&"")) -- Biff Microsoft Excel MVP "Cassie" wrote in message ... hi How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count unique names in a list
For range of B1:B20.
=SUMPRODUCT((B1:B20<"")/COUNTIF(B1:B20,B1:B10&"")) "Cassie" wrote: hi How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count unique names in a list
Brad
Thanks this works fine What would the formula be if I also needed to count all the unique names by month. The months are in col c. the names appear multiple times in the file at least once in each month - I only want to count John Smith once in January but his name appears 4 times. Cassie "Brad Vogt" wrote: For range of B1:B20. =SUMPRODUCT((B1:B20<"")/COUNTIF(B1:B20,B1:B10&"")) "Cassie" wrote: hi How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count unique names in a list
He's behind you
-- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "T. Valko" wrote: One way... =SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&"")) -- Biff Microsoft Excel MVP "Cassie" wrote in message ... hi How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count unique names in a list
I know!
-- Biff Microsoft Excel MVP "Mike H" wrote in message ... He's behind you -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "T. Valko" wrote: One way... =SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&"")) -- Biff Microsoft Excel MVP "Cassie" wrote in message ... hi How do I count a list of names, some names appear more than once. I only want to count unique names. I use excel 2007 Thanks Cassie . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Numbers if Names Match | Excel Worksheet Functions | |||
| how can i count the number of unique names in a list | Excel Discussion (Misc queries) | |||
| Unique names in a list reported everyday | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
Linear Mode
