We can also use Remove Duplicates on a single column, by unchecking all boxes, then checking the column. If it finds a match then it will delete that row. That means each cell in the row has to be identical to the values in each cell of another row. If we leave all checkboxes checked, then Excel will look for entire duplicate rows. This brings up the Remove Duplicates window where we can select which column(s) we want Excel to remove duplicates from. We can select a range or Table, then press the Remove Duplicates button on the Data tab of the Ribbon. Method #1 – The Remove Duplicates FeatureĮxcel has a built-in feature called Remove Duplicates that does most of the work for this task. That means the entire process can be completed with a click of a button, and save us a lot of time. Then we will look at a faster method by using a macro to create a list of unique values.
EXCEL REMOVE DUPLICATE ROWS HOW TO
In this article we'll look at how to use the Remove Duplicates feature of Excel for this task, the time consuming method.
This process can require multiple steps and be a bit time consuming. We typically want to extract this list of uniques from a column in a table/range that contains duplicate values. We can use the list for a lookup table, summary report, drop-down menu, etc. One common task we do as data analysts is creating a list of unique values from a column in a data set.
Remove-Duplicates-List-Unique-Values-Macro.zip Download Creating a List of Unique Values