Removing Duplicates to another sheet

[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

 

[Ms-Exl-Learner]

Have a look about Advanced Filter. But it will move the Original Values to a
New Place.

2007 - Data>>Sort&Filter>>Advanced

See some examples in the below link for more details about advanced autofilter

http://www.contextures.com/xladvfilter01.html

If this post helps, Click Yes!