| Home |
| Search |
| Today's Posts |
|
#4
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 . |
| 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 | |||
Threaded Mode
