Here is the macro code that you can copy to your own VBA Project. The macro can be run on any column in any open workbook.
Free dupe away how to#
So, I recommend copying your data to a new sheet first or duplicating the sheet.Ĭheckout my article on 17 Excel Shortcuts for 2017 for tips on how to duplicate a sheet. This means you could potentially lose data if you run Remove Duplicates on your original source data range/Table. It does NOT copy the data to a new sheet first. It's really important to know that the Remove Duplicates feature deletes rows on the selected range. There are quite a few steps in this process, and an additional step if your column contains blank cells that you also want to remove… Use Remove Duplicates with Caution Therefore, we first need to copy the column to a new sheet, then run the Remove Duplicates feature on that single column. We really just want a list of the unique values on a new sheet in the workbook. This can be useful in some scenarios, but it's not really what we want for our list of unique values. The first row that contains the unique value is kept, and all other rows below that contain a duplicate for that cell in the column are deleted. This will delete all rows that contain a duplicate value in the single column. 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. 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.
Free dupe away download#
Remove-Duplicates-List-Unique-Values-Macro.zip Download Creating a List of Unique Values
0 kommentar(er)
