Thread: Duplicates?
View Single Post
  #1   Report Post  
Zip Codes
 
Posts: n/a
Default 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?