Thread: Count Duplicate Values
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 Count Duplicate Values
It is very to use a Pivot Table to do this. The Pivot Table can be made to
list each unique item in the list and next to the number of times the item
appears. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200771


"Abdul Shakeel" wrote:

Hi All,

Is there any way to count duplicate values in a range.
Reply With QuoteReply With Quote