Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marking Duplicates | Excel Worksheet Functions | |||
Finding Duplicates | Excel Worksheet Functions | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |