Filter Duplicate Values in Excel Without Removing Them

Excel has functionality within the Data menu to remove duplicate values. However, Excel does not have a built-in way to simply filter the duplicate values. By filtering the duplicates, rather than removing them, we have the option to either see the first instance of our values or show all of the duplicate instances of our values. This video shows two examples built around COUNTIF/COUNTIFS or MATCH that allow us to filter duplicate values without removing them. Unlike the Remove Duplicates option, these solutions leave our data intact. This video shows these equations being entered in an additional column. They could just as easily be used as part of conditional formatting to highlight our values if you don’t want to add the additional column. Thanks for watching. TIMESTAMPS: ==================== 0:00 Introduction 0:29 Outline 1:37 Single Variable: COUNTIF 5:25 Single Variable: MATCH 9:57 Multiple Variables: COUNTIFS 11:32 Multiple Variables: MATCH 13:01 Wrap up UNSPLASH IMAGE: ==================== Photo by eberhard 🖐 grossgasteiger on Unsplash