View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How to count the unrepeated objects on a excel list

See:

http://www.cpearson.com/excel/Duplicates.aspx

scroll down to:

Counting Distinct Entries In A Range
--
Gary''s Student - gsnu200743


"raul acosta" wrote:

Frequently I have to use a pivot table to count first column unrepeated
elements. Is there a function to do this?