Remove duplicate

**sophiaatwedding** · 12-03-2010, 02:33 AM

Hello Guys!!!

How to compare and remove duplicate in excel 2007

**TMS** · 12-03-2010, 03:15 AM

I think you're going to need to provide a little more detail. Duplicates in what respect?

Please upload a sample workbook and explain the before and after scenario.

Regards

**royUK** · 12-03-2010, 04:30 AM

See this MS Office article

**teylyn** · 12-03-2010, 04:50 AM

In addition to the article linked to above, which applies to Excel 2002 and 2003, and seeing that you are using Excel 2007, you could click the Data ribbon and then the "Remove Duplicates" button.

Tick the respective check boxes and click OK.

If you are indeed on Excel 2007, please update your profile to reflect this. There are so many different ways to achieve things in the Excel versions out there, that it is really helpful to know what Excel version you are using. If you put it in your profile, you don't have to type it in each post. Since you just joined, I guess you did not pay attention to the option in the registration dialog. Please correct that now.

cheers,