| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove duplicate records in Excel file
How can I remove duplicate records in an Excel file of names & addresses? I
have combined several lists from different sources. I think the main issue is all caps vs upper & lower case. Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove duplicate records in Excel file
You can use advanced filter to do this or even the autofilter, it all
depends on how the spreadsheet is setup, Could you post some more info? The advanced filter although it is one of the least used parts of Excel is extremely powerful once you get the hang of it. -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "KAatIGA" wrote in message ... How can I remove duplicate records in an Excel file of names & addresses? I have combined several lists from different sources. I think the main issue is all caps vs upper & lower case. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text records in Excel | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| How do I delete duplicate records from an entire Excel workbook? | Excel Discussion (Misc queries) | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
| how to overcome excel file limitaions (65,000) records only? | Excel Discussion (Misc queries) | |||
Linear Mode
