Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records
Wondering how to find duplicate data in Excel? This simple formula can save you loads of time by helping you filter and delete duplicate cell data.
There are a number of ways to do this, but I’ve found this to be the easiest way to perform this function, especially if you have hundreds or thousands of cells to analyze.
You sometimes need to use Excel to check in a data set where there are duplicate values.