Find missing or changed values
Find extra occurrences when both lists contain the same values
Find extra copies of codes even when both lists contain the same codes. Compare each occurrence and see which copies have no match.
Find missing or changed values
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Find missing or changed values
Compare changes when the main ID repeats
Match records using a main ID and line ID that stay unchanged, then compare other values. A repeated main ID alone cannot identify the right pair.
Find missing or changed values
Detect a change from blank to zero
Compare values by ID while preserving the difference between missing data and a recorded zero.
Find missing or changed values
Reconcile invoice lines with statement totals
Sum invoice line items to one row per invoice, save the totals, then compare against the statement to reveal amount differences and missing invoices.
Find missing or changed values
How to find changed values when Excel rows are in a different order
Find changed customer details even after the list is sorted differently. Match customer IDs first, then separate changed, unchanged, new and missing records.
Find missing or changed values
How to compare two Excel tables when there is no unique ID
Check whether the same product-and-region requests appear in two files. Compare the columns together to catch differences a product-only check would miss.