Posted by Brennan M on January 04, 2002 7:52 AM
I have a sheet with around 3000 entries and 15 column headings. Some of the entries are duplicates based on data in one column. I need to be able to move all of the duplicate entries EXCEPT for one (if there are 8 duplicates, I need to move 7) from sheet 1 to sheet 2. Or, if there is a conditional format I can use to highlight the duplicates and move them manually, that would work as well. Suggestions? Thanks in advance!