Removing Duplicates to another sheet

  • Thread starter Thread starter Pierrette T
  • Start date Start date
P

Pierrette T

I am new at sorting large files in Excel 2007. I have multiple columns, but
need to find the duplicates and process them. I would like to find a way to:

1. Identify duplicates quickly without going through and labeling them by
hand.

2. Once I sort for all the duplicates, I want to eliminate all but the top
entry from my list.

3. I want all the duplicates to go to another sheet in my workbook.

Can this be done?

Thanks,

Pierrette T
 
Back
Top