View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Anvil22 Anvil22 is offline
external usenet poster
 
Posts: 23
Default 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