Clean up and summarize data
Find every text match within a date range
Combine a description Contains filter with a date range to extract all matching detail rows, including times on the final date.
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.
Append sheets
Append only the detail worksheets from a workbook
Combine a workbook’s monthly detail sheets without counting the summary twice. Exclude unwanted sheets before appending.
Clean up and summarize data
Calculate each item’s share of its region’s total
Find each item’s share of sales within its own region. Save item and regional totals, join them by region, then calculate the percentages.
Clean up and summarize data
Sort ISO timestamps with offsets in actual time order
Put events from different time zones in chronological order. Convert timestamps with explicit offsets to Date & time and sort the UTC values.
Clean up and summarize data
Why does 10 sort before 2? Convert numeric text before sorting
Set quantity columns to Number so values sort as 1, 2, 10 instead of 1, 10, 2. Keep codes and identifiers as Text.
Clean up and summarize data
How do you calculate 20% off followed by another 10%?
Calculate one discount after another using the reduced price at each step. Check why 20% off followed by 10% off is not the same as 30% off.