![]() Select the entire data set (including the headers).Here are the steps to get all the unique records: In such a case, you can use Excel Advanced Filter tool to quickly get a list of all the unique records in a different location (so that your original data remains intact). These could be due to an error in data entry or result of data compilation. Suppose you have a dataset as shown below:Īs you can see, there are duplicate records in this data set (highlighted in orange). Let’s see how to use an advanced filters to get a unique list. Excel Advanced filter would allow you to select a location to get a unique list. To keep the original data intact, you need to create a copy of the data and then use the Remove Duplicates option. In Excel 2007 and later versions, there is an option to remove duplicates from a dataset. ![]() You can use Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). Now let’s have a look at some example on using the Advanced Filter in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |