Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Keep AB10 and ab10 as separate product codes and return the correct name for each. Check the matching rule and prevent extra matches caused by ignoring letter case.
Count each customer once within a region, even if they placed several orders. Use two summaries to turn an order list into regional customer counts.
Find how many different codes are duplicated in a list. Count each repeated code once, whether it appears twice or many times.
Find out why two orders become six rows after a join. Check duplicate customer IDs and add the missing condition to join each order to the right address.
Find accounts whose combined transactions reach your target amount. Add up each account first so smaller transactions are included before you filter the totals.
Calculate each team's minimum, maximum and average processing time without treating missing durations as zero. Check what happens when an entire group is blank.
