Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel’s FILTER() function. There are a number of ways to highlight duplicate values.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results