excel - removing duplicate entries in spreadsheet

P

prh

i have a spreadsheet with over 5000 names and adresses. many of these are
duplicated. is there an easier way to delete duplicates other than re-sorting
data to appropriate column and deleting line by line?
 
R

Ron Coderre

You might want to try an Advanced Filter

Select your data list.
From the Excel main menu:
<data><filter><advanced filter>
Check: Copy to another location
Check: Unique records only
List Range: (already selected)
Copy to: (select a cell off to the right)
Click the [OK] button

A list of the unique records will be generated at the cell you selected.

Also, be aware of the following kinds of issues....
Examples:
John Q, Public
John Q Public
John Public
JQ Public
101A Main Street
101-A Main Street
101 A Main St
etc

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Top