| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete duplicate rows
i have a spreadsheet with duplicate email entries.
anyone know of a macro that can go down through the rows, check to see if an email address is in any previous rows and if so delete all remaining rows that contain that duplicate email address? cheers, rhys. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete duplicate rows
Rhys,
One method is to use the Advanced Filter (Data/Filter/Advanced Filter) with the Unique Records Only option and no criteria. To find how to use this in VBA use the macro recorder. Cheers, Dave. -----Original Message----- i have a spreadsheet with duplicate email entries. anyone know of a macro that can go down through the rows, check to see if an email address is in any previous rows and if so delete all remaining rows that contain that duplicate email address? cheers, rhys. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete duplicate rows
Hi,
You can also see this link. http://www.cpearson.com/excel/deleting.htm Look for DeleteDuplicateRows macro. Regards, Shah Shailesh -----Original Message----- i have a spreadsheet with duplicate email entries. anyone know of a macro that can go down through the rows, check to see if an email address is in any previous rows and if so delete all remaining rows that contain that duplicate email address? cheers, rhys. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete duplicate rows, keep one | Excel Discussion (Misc queries) | |||
| Delete rows with duplicate values | Excel Discussion (Misc queries) | |||
| delete duplicate rows | Excel Worksheet Functions | |||
| Delete rows with duplicate values | Excel Worksheet Functions | |||
| How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
