View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roshlin Roshlin is offline
external usenet poster
 
Posts: 9
Default How to count duplicate or repeat values

Hi friends,

I have 6 columns with 100 names, I would like to count how many the names
appear in the differnt columns and have the results on the same or another
sheet with the number of times the name repeates
eg.
Paul 4
Mike 3
Sandy 2
and so on,

Thanks for your help