Replace Duplicate Rows
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?
Re: Replace Duplicate Rows
The formula below will display the words "Duplicates" or "No Duplicates" indicating whether there are duplicates elements in the list A2:A11.
For more information go here.
Education, Career and Job Discussions
|Tags: code, columns, excel, macro, rows|
|Thread Tools||Search this Thread|
|Similar Threads for: "Replace Duplicate Rows"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Delete duplicate rows using Macros||Dyumani||Windows Software||5||12-10-2011 11:30 AM|
|How to combine data in duplicate rows in MS excel||Virginia||Windows Software||7||10-07-2011 11:13 AM|
|How can I highlight duplicate rows of excel sheet with color?||Sarfaraj Khan||Windows Software||5||08-01-2010 10:15 AM|
|Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003||awkwardsmile||Software Development||2||09-07-2009 08:57 AM|
|Need script to identify duplicate rows||Dwij||Software Development||4||30-06-2009 05:21 PM|