View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
Reepo Reepo is offline
external usenet poster
 
Posts: 1
Default How do I find duplicate entries in a column in an Excel worksh

I know how to find duplicated records, but my problem is that I need to know
where does the value is repeated. Home my ASCII art illustrates what I need.
A B C
1 - a 2x - A4
2 - b 1x - A6
3 - c 1x - 0
4 - a 2x - A1
5 - d 1x - 0
6 - b 2x - A2
7 - e 1x - 0

A show the values
B show how many times the value is repeated
C Shows the cell, or cells where the exactle value is.
Im not sure if its posible to do so, but I had to ask.
Thanks.