Duplicates?
 

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?

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?