Append sheets
How to combine Excel sheets when the columns are in a different order
Append monthly sales by matching column names rather than positions. Check the four-row result, sales total and limits when headers are missing or different.
Make spreadsheet work simpler
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Clean up and summarize data
Should uppercase and lowercase product codes match?
Decide whether ABC and abc identify the same item before joining. Compare case-sensitive matching with Ignore letter case while preserving original values.
Append sheets
How to combine transaction files and sort them by date
Append transaction sheets, then sort the combined result by date and transaction number. Preserve all records and check the total before saving.
Find missing or changed values
How to compare changed values in Excel files with different row orders
Match records by customer ID before comparing their values. Identify changed, unchanged, added and missing records without relying on row positions.
Find missing or changed values
How to compare two Excel tables when there is no unique ID
Compare product-and-region combinations instead of a single column. Find shared and unmatched records without inventing an ID or assuming a change occurred.
Clean up and summarize data
How to count unique customers by region without counting repeat orders
Group by region and customer ID, then count those combinations by region. Separate order counts, regional customer counts and company-wide unique customers.