Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

Windy wrote:

I have a spreadsheet containing multiple tabs of names and addresses. I
wantto have a master tab so I copied and pasted from tabs 2, 3, & 4 to tab 1.
I want to check tab 1 for duplicates and erase the duplicate lines. How can
I first find those duplicates so I can visually check them before I manually
erase them?

--

Dave Peterson