Replace Duplicate Rows

[ajk79]

Sponsored Links

I am new to macros and need some help. I have found numerous code for deleting all but the first instance of a duplicate row. However, I need something a little different. I have a table with about five columns of data. I need a macro that will search column 1 for duplicate entries and replace the first instance with the last one. Does anyone know if this is possible?

[EINSTEIN_007]

The formula below will display the words "Duplicates" or "No Duplicates" indicating whether there are duplicates elements in the list A2:A11.

=IF(MAX(COUNTIF(A2:A11,A2:A11))>1,"Duplicates","No Duplicates")

For more information go here.