View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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