excel find duplicate rows and blank them out

Once again, start by selecting the column that contains the duplicate values. Also note that this method is suitable if duplicate values reside in the same column. Fortunately, you can use the Advanced Filter feature to remove them at once. However, the manual approach obviously might take too long if there is a lot of duplicates. How to remove duplicate valuesĪfter you find duplicates in Excel, you can select rows one by one and delete them. Let's continue with how you can remove those duplicate values. Thus, you don't need to update this feature every time you get new duplicates. The good thing about this method is that Conditional Formatting works with every calculation. In our list, 'WATER' and 'FIRE' values are listed more than once. You can select between highlighting duplicate values or unique values in a specific style.Ĭlicking the OK button applies the specified formatting to the selected range. In the Ribbon, follow the path Home > Conditional Formatting > Highlight Cell Rules > Duplicate ValuesĬlicking the Duplicate Values item pops a dialog with more options. Let's see how you can do this using an example.įirst select the range of your data (You can select a range or a list).

With only two steps, you can change the color of the cells that have duplicate values.

If you only want to locate the duplicate values, highlighting them is probably the easiest way to do so. In this guide, we're going to show you how to find duplicates in Excel and also go over how you can remove or consolidate them using a few examples.ĭownload Workbook How to find duplicates in Excel Duplicate values in a dataset can cause headaches if you do not know how to deal with them.

Excel find duplicate rows and blank them out