Removing Duplicates to another sheet
 

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

Removing Duplicates to another sheet
 

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

2007 - DataSort&FilterAdvanced

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!

--------------------
(MS-Exl-Learner)
--------------------


"Pierrette T" wrote:

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