| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i count the number of unique names in a list
I hace a list with multiple same names. in excel how can i count each name
once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
This formula returns the count of unique items:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Adjust range references to suit your situation. In your posted example, 5 names are listed, but smith is listed twice. Consequently, there are 4 unique names. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Anvil22" wrote in message ... I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
See:
http://www.cpearson.com/excel/Duplicates.aspx -- Gary''s Student - gsnu200769 "Anvil22" wrote: I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
Not that it's important...but, my comment should have been:
In your posted example, 6 names are listed, but smith and west are listed twice. Consequently, there are 4 unique names. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Ron Coderre" wrote in message ... This formula returns the count of unique items: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Adjust range references to suit your situation. In your posted example, 5 names are listed, but smith is listed twice. Consequently, there are 4 unique names. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Anvil22" wrote in message ... I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
Ron,
It worked - greatly appreciated- thank you. "Ron Coderre" wrote: Not that it's important...but, my comment should have been: In your posted example, 6 names are listed, but smith and west are listed twice. Consequently, there are 4 unique names. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Ron Coderre" wrote in message ... This formula returns the count of unique items: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Adjust range references to suit your situation. In your posted example, 5 names are listed, but smith is listed twice. Consequently, there are 4 unique names. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Anvil22" wrote in message ... I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
Gary,
Neat answers. Thanks Dick "Gary''s Student" wrote: See: http://www.cpearson.com/excel/Duplicates.aspx -- Gary''s Student - gsnu200769 "Anvil22" wrote: I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i count the number of unique names in a list
You're very welcome......I'm glad I could help.
Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Anvil22" wrote in message ... Ron, It worked - greatly appreciated- thank you. "Ron Coderre" wrote: Not that it's important...but, my comment should have been: In your posted example, 6 names are listed, but smith and west are listed twice. Consequently, there are 4 unique names. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Ron Coderre" wrote in message ... This formula returns the count of unique items: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Adjust range references to suit your situation. In your posted example, 5 names are listed, but smith is listed twice. Consequently, there are 4 unique names. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Anvil22" wrote in message ... I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith jones smith west east west total 5 names. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique names in a list reported everyday | Excel Worksheet Functions | |||
| Finding unique names--then converting those names to unique number | Excel Discussion (Misc queries) | |||
| List Unique Occurences and Count | 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
