How to use the remove duplicates in excel tool to remove duplicates by simply specifying what you consider a duplicate.
One on the great new tools available in Excel is the Remove Duplicates in Excel button which is found under the Data Tab. It does exactly what it says – it removes duplicates.
If you go to a Data Base, you can clearly see that the items in yellow are exact duplicates of each other. Highlight the whole worksheet. Click on Remove Duplicates. What you’ll see is that a window opens, you’ll see it says “my data has headers” which in this case is appropriate- but you can switch it off if its not appropriate. What this is saying is that when it considers a duplicate, it is going to look for a duplicate in every single column – Sales person, Product A,B,C etc. Press OK. It tell me how many duplicates it has found and what it has done. When I click OK, the duplicates are all removed. Let’s just undo this and do it again- highlight the area, click Remove Duplicates and in this case we can say consider duplicates only in the Salesperson column- when I say OK, a lot more duplicates have been found – it has only left 8 unique values and when I click OK you’ll see there is only one Salesperson per line and no other duplicate values. Please note that because Excel is deciding what is and isn’t a duplicate, it is highly recommended that before you use this, you establish some sort of control total of what you expect the answer to be. Just check that Excel hasn’t accidentally deleted too many or for whatever reason, because of a space or something like that, it has not deleted an item.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”– Absa Capital