How to Compare Two Excel Spreadsheets for Duplicate Rows. Excel 2013 can locate duplicate rows as long as one column contains a unique identifier for each record, such as a product ID or account ...

You can use Microsoft's Spreadsheet Compare tool to get a color-coded chart showing how two spreadsheets compare and what's missing or changed from one to the other.

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done. Comparing lists for common values, or duplicates is a task that often has many variables.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.