Eternal731
Board Regular
- Joined
- Jun 16, 2009
- Messages
- 55
Hello all,
I was wondering if anyone knew of a way to do the reverse of the Delete Duplicate Function in Excel on the Data Tab.
Where the function allows you to select column headers to check for, then finds the records that are duplicates and deletes only the duplicate.
I would like a macro that does the opposite, allows me to keep all of the duplicates and delete the unique records only. Leaving me with both of the records that contained the specified column info ("=RC2&""-""&RC3&""-""&RC6").
I was wondering if anyone knew of a way to do the reverse of the Delete Duplicate Function in Excel on the Data Tab.
Where the function allows you to select column headers to check for, then finds the records that are duplicates and deletes only the duplicate.
I would like a macro that does the opposite, allows me to keep all of the duplicates and delete the unique records only. Leaving me with both of the records that contained the specified column info ("=RC2&""-""&RC3&""-""&RC6").
Last edited: