In this situation, the word find is a bit misleading. This feature won’t find the duplicates: It will filter them from the results, giving you a unique set of records.

One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how. Step 1: Select the portion of your data where you want to locate duplicates.