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
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
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.
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.
Clean up and summarize data
Keep multiline CSV cells inside one record
Import a CSV with line breaks inside quoted cells without splitting one record into several rows. Check the record count and saved cell contents.
Clean up and summarize data
Calculate a selling price from cost and target margin
Find the selling price needed for your target margin with two calculations. Use 0.2 for 20% and check margin against the selling price.
Clean up and summarize data
Calculate a team-wide rate from individual amounts
Sum budget and spending separately, then divide total spending by total budget. Adding or averaging individual percentages answers a different question.