Clean up and summarize data
Find the most common value in each group, including ties
Count each value within its group, find the highest frequency per group, and join on both fields to keep every tied mode.
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
Calculate NPS by group from survey scores of 0 to 10
Map each valid survey score to −1, 0 or 1, then average by group and multiply by 100. Keep passive responses in the denominator.
Clean up and summarize data
How many customers ordered once, twice, or three times?
Count orders per customer, then group those counts to build a customer frequency table.
Clean up and summarize data
Find rate differences within ±5 percentage points
Compare two rates and keep differences from −5 to 5 percentage points, including both limits. Distinguish this from percentage change.
Append sheets
Why do duplicate-looking rows remain after I hide a column?
Duplicate removal checks every source column, even hidden ones. Show hidden fields to find why two rows that look identical both remain.
Clean up and summarize data
Keep long identifiers intact when importing
Keep every digit of long account or order IDs by importing the original text values and matching them as Text.