Chip Pearson has information on finding and tagging duplicate entries in
a list.

http://www.cpearson.com/excel/duplicat.htm


hmadari wrote:
I know how to filter out the duplicates, but I want to see exactly which ones
were duplicates. Any way to do this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html