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