Macro to Remove Duplicate Entries From a List

[Michael151]

Hello all,

I have two columns - "Title" and "Notes" (identified in row 1 header).

If these columns contain multiple rows that are an identical match, then keep only 1 row (basically eliminate duplicates). For example:

Before:

Title Notes
Title1 Notes1
Title2 Notes2
Title2 Notes2
Title3 Notes3
Title4 Notes4
Title4 Notes4
Title4 Notes4

After:

Title Notes
Title1 Notes1
Title2 Notes2
Title3 Notes3
Title4 Notes4

Notice that the duplicates for Title2 and Title4 were removed since there were multiple matching rows - only one instance is kept.

Help is appreciated - thank you!

 

[Michael151]

also, obviously if there are no duplicates, then do nothing.

If there are no entries at all (nothing in Title or Notes columns), then do nothing.

 

[reza_doang]

Michael...

I found an interesting add ins for duplicate entries
please follow this link
http://tech.xnepali.com/free-excel-add-in-the-duplicate-master/

reza

 

[Marcelo Branco]

Hi,

I think you can use Data>Remove Duplicates selecting both columns

HTH

M.

 

[Michael151]

Thanks all - how would I incorporate this into a macro?

Thanks.

 

[Michael151]

Nevermind - just found my solution, thanks!!