This article is basically about:
how to make unique records using excel 2007; or
how to make distinct records using excel 2007; or
how to eliminate duplicate records on excel 2007
The case is, I use an excel file imported from SAP. The file contain duplicate records, meanwhile I need to clean this records so that I can a have a clean, unique records. Since I haven’t been exploring Excel 2007 a lot. I thought that there’s no way we can use Excel feature to do all the work. I almost thought that I have to do that all manually. Oh no, this can’t be good, since there was thousands of records to check.
So, I start to explore excel features, and Voila!! There it was. It was there all along. All I need to do is:
- Go to the Data menu (you can find it on top of Excel)
- Look for the Remove Duplicates function. It’s on the Data Tools group.
- Follow the wizard. Quite simple to understand the instructions on the wizard.
Well, I guess I need to explore Excel more 
. It can be very helpful.
2 Comments
Useful tip, sounds a bit like they’ve renamed the Advanced Filter copy unique records function.
Actually the Advanced Filter are also there. I guess it’s an additional function they provide in excel, or maybe it was there all along and I didn’t notice. My bad, haven’t been exploring excel that much.