Are you trying to gain unique values from a large or small list of repeating records? Elimination of duplicates is common question on training, so I put here how to do it in Excel 2007 and newer. Earlier this was possible only by using advanced filter, which allowed the filtering records without duplicates. In Excel 2007 version it easier for us by the Data tab where we find the button that will do it much faster.
Firstly, let us make a sample with which you can encounter: We have a list of all our clients and they are obviously from different countries. We are interested in the list of countries from which we have clients, but we want only unique values. Each country we want to write in the list only once, and not a hundred times for a hundred clients.
To remove duplicates in Excel use the Data tab and click Remove duplicates. The exact procedure is as follows:
- Copy the list of repeating values including a header (column name) into an empty area
- Select the copied range and activate the Remove duplicates button on the Data tab
- Make sure that Excel selects the correct column, and whether it is checked that the data includes header
- Removing duplicates is done 🙂
If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.