Excel Tips: Data > Compare Data

Compare Cells

How to compare adjacent cells with Conditional Formatting icon sets in Excel?

How to compare if multiple cells are equal in Excel?

How to compare numbers but allowing a tolerance in Excel?

How to compare two cells and return Yes if they are matched in Excel?

How to compare two numbers with decimal numbers in Excel?

How to compare two strings for similarity or highlight differences in Excel?

How to easily compare cells by case sensitive or insensitive in Excel?

How to exactly compare two strings (case sensitive) in Excel?

How to match dates by month and year only in Excel?

Compare Lists (Columns)

How to compare alphanumeric values in two columns in Excel?

How to compare two columns and count differences in Excel?

How to compare two columns and delete matches in Excel?

How to compare two columns and find the duplicate or missing values in Google sheet?

How to compare two columns and highlight the unmatched data in Excel?

How to compare two columns and highlight when found in another column?

How to compare two columns and list differences in Excel?

How to compare two columns and return values from the third column in Excel?

How to compare two columns for (highlighting) missing values in Excel?

How to compare two lists of email addresses in Excel worksheet?

How to exclude values in one list from another in Excel?

How to highlight cell if value exists in or equals to cell in another column in Excel?

How to highlight cells if not in another column in Excel?

How to highlight column differences in Excel?

How to vlookup to compare two lists in separated worksheets?

Compare Sheets

How to compare two sheets in same workbook or different workbooks?

How to compare two worksheets in a workbook or two workbooks for differences in Excel?