| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel - removing duplicate entries in spreadsheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel - removing duplicate entries in spreadsheet
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 "prh" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
| NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL | Setting up and Configuration of Excel | |||
| How do I delete duplicate entries in excel? | New Users to Excel | |||
| How do you prevent duplicate entries in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
