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.
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.
Join data
Preserve blank source values in a lookup result
Keep blank amounts blank when joining sheets, and display the matching ID to tell missing values, recorded zeros and missing matches apart.
Join data
Keep records with missing IDs separate when joining both lists
Keep records from both sheets without matching genuinely blank IDs to each other. Retain source references so you can investigate them.
Join data
Keep master records that have no matching details
Keep every item in your master list when adding details from another sheet. Show missing matches as blanks without losing the master records.
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.