| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
automatically delete records w/duplicate address in excel
Don't have MS Access.
I have a voters list......w/lot of records with duplicate addresses. IE married couple both vote and live at same address. I only need one record for each address. How can I automatically delete each record w/duplicate address keeping 1 record with that address? |
|
#2
|
|||
|
|||
|
First off, do not work on the original file. Work on a copy!!
Go to Chip Pearson's site for a macro to do this http://www.cpearson.com/excel/deleting.htm "PUSH" wrote: Don't have MS Access. I have a voters list......w/lot of records with duplicate addresses. IE married couple both vote and live at same address. I only need one record for each address. How can I automatically delete each record w/duplicate address keeping 1 record with that address? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i delete multiple records from my database | Excel Discussion (Misc queries) | |||
| Automatically insert row between groups of records | Excel Discussion (Misc queries) | |||
| stop automatically making email address | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Linear Mode
