Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate Disaster
I have a huge table in excel, about 1500 addresses. The problem is some of
them are duplicates. The bigger problem is that if they are duplicates there is a slight difference in their name. for example 123 designer might be 123 desginer co. but with the same phone number etc. So the phone number is the only piece of data that would be the same for a duplicate. Is there a way to have excel find all the duplicates in the column with phone numbers then delete one of the duplicate rows? i've tried that website with the duplicate tutorials doesn't work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping duplicate rows | Excel Worksheet Functions | |||
Duplicate information | Excel Discussion (Misc queries) | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |