Chip Pearson's site explains how
http://www.cpearson.com/excel/deleting.htm
"Zip Codes" wrote:
I have a lot of data that i have cut and pasted from various sources, company
names and phone numbers that looks like this
a b
company x 555-111-2222
the only problem is some of the sources overlap so i have several companies
and phone numbers listed twice. However, sometimes the company names are
different but are in fact the same place. The phone numbers however are the
same. I need to find the duplicate phone numbers and delete those rows, any
way to do this without going through one by one?