Join data
Keep the latest record for each ID, including all its columns
Find the highest version for each product, then join on product ID and version to retrieve the full record. Tied latest versions are kept.
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
Keep notes with the right record when rows change order
Store notes with a stable record ID, then join them to each updated report so changes in row order do not move notes to the wrong record.
Join data
Extract unmatched records with their details
Find records missing from a completed list while keeping their names and amounts. Join the lists, then filter for missing matches.
Join data
Keep whole groups when any member meets a condition
Keep every row in a group if at least one value meets your condition. Find the qualifying groups, then join them to the original records.
Join data
Look up a manager in the same roster
Find each employee’s manager by joining two copies of the staff roster. Keep employees who have no manager listed.
Join data
Look up the submitter and approver from one staff list
Add submitter and approver names to transactions using two copies of the staff list, while keeping transactions with missing staff entries.