Thread: how to count unique values and show each different one
View Single Post
  #4   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 unique values and show each different one
Use a Pivot Table. It will produce a nice listing of each unique code with
the number of times it occurs.

http://peltiertech.com/Excel/Pivots/pivottables.htm
--
Gary''s Student - gsnu200853


"mmwrites" wrote:

I have a long column of ZIPS. I need a formula that will tell me which ZIPS
I have and how many there are of each.
Reply With QuoteReply With Quote