Comparing Files

Calculate the variance in amount and percentage, summarize expenses by line item and highlight anything beyond your threshold, with ready-to-copy formulas.

A step-by-step method to compare two versions of a customer or subscriber list in Excel and find out who is new, who has left and which details have changed.

Formulas and conditional formatting to see which values match between two columns, which are missing from one of them and how to extract them into a separate list.

Learn how to compare two Excel files step by step, which kinds of differences to look for, and how to get a clear report of the changes without checking cell by cell.

We look at the advantages and limits of comparing spreadsheets by hand, with formulas, with built-in Excel features and with free online tools.

Best practices for naming, storing and comparing versions of your Excel workbooks so you always know who changed what and when.

A practical method to review supplier price lists, spot hidden increases, removed products and errors before you update your catalog.

How to match your physical inventory with your system stock using Excel: prepare the data, compare quantities, find discrepancies and fix them.

The most frequent pitfalls when comparing spreadsheets, from swapping the file order to invisible spaces, and how to avoid each one.