Deleting Duplicate Entries

Im a total noob...sorry if this is a really basic question.


I need help with sorting our company mailing list in Excel. Specifically I need help in deleting duplicate entries. I know how to delete duplicates but I don't know how to delete them in such a way that it deletes the entire row even though I am only deleting duplicates from a single column. Does that make sense? I want to be able to search the Address column for example and find duplicates but when I delete the duplicate Address's I want the entire row to delete with it (even if the rest of the entries i.e. Name or email address is different). This way when I delete them all the information still lines up.

Thank you in advance!

Try it out

Please Login or Register  to view this content.

You could easily do this without VBA by using Advanced Filter with the option to copy unique values to a new location.

If this is something you will do often, automating Advanced Filter is faster than looping through a lot of cells.

Excel Advanced Filter

Palmetto

Originally Posted By kblinkin
but when I delete the duplicate Address's I want the entire row to delete with it (even if the rest of the entries i.e. Name or email address is different).

Thats why I posted macro. As I know advanced filter doesnt get unique values from multiple columns...

Thats why I posted macro. As I know advanced filter doesnt get unique values from multiple columns...

Got too focused on this and overlooked the multi-column aspect of the issue.

even though I am only deleting duplicates from a single column

General rule of thumb, when offering macros in the non-programming forum, especially to self-professed Excel newbies, always include a boilerplate instruction set on how to install/activate them.

Something like:
============
How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Assuming that:

1) Row 1 is titles, not part of the data, then we can use an autofilter to delete all the duplicates all at once.
2) You want to keep the first instance of each value in the designated column (MyCol in the macro)
3) You edit this macro so that MyCol is the column number you wish to evaluate by

Please Login or Register  to view this content.