Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques. Follow the steps in the add-on wizard to choose the range and columns you'd like to check for ...

Launch Excel. Open the worksheet containing the excess Tab symbols that you want to remove. Open the "Find and Replace" dialog box by pressing "Ctrl-H" on your keyboard. Alternatively, click "Find ...

Click OK, and Excel will move or copy the sheet to the target workbook. If you move to the target workbook file, which is still open, you will find a copy of the source worksheet.

Using Excel’s conditional formatting to highlight duplicates in a single column is one way to find them quickly, although there’s less motive to delete duplicates in this situation.

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.