Join data
Find missing items when each account type has different requirements
Check each account against the items its type requires. Find missing assignments even for accounts with no records at all.
Join data
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Join data
Find the nearest numeric reference and keep ties
Find the closest reference number above or below each target. Compare squared differences and keep both references when they are equally close.
Join data
Find pairs of overlapping numeric ranges
Find ranges that overlap, including a range contained inside another. Compare each pair once and leave out pairs that only touch at an endpoint.
Join data
Generate every pair from two lists
Create every color and size combination by joining on a column filled with the same value. Two colors and three sizes produce six pairs.
Join data
Join different code systems through a mapping table
Join sales codes to a mapping table, then add product descriptions from the catalog without losing unmapped sales.
Join data
Join workbooks that use different Excel date systems
Match dates across workbooks that use Excel’s 1900 and 1904 date systems by importing the original XLSX files.