How to Find Duplicates in Excel & Highlight Duplicates If You Need To

Microsoft Excel Tips and Tricks

In this video I’ll show you 4 ways on how to find duplicates in your Microsoft Excel data. We’ll find solutions regardless if your data is in the same column, in separate columns and even if you need to find duplicates for a combination of cells. You’ll learn how to use conditional formatting to color duplicate values, how to look inside an entire row and compare one row with another and flag it is a duplicate. As a bonus you’ll learn how to use a dynamic formula to flag duplicate entries with an icon or returns just the duplicate entries.

Credit Leila Gharani