Clean up and summarize data
How many customers ordered at least twice from each vendor?
Count customers with at least two orders from the same vendor, without mistaking multiple items in one order for repeat purchases.
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
How can I include no-sales days in a daily average?
For a shared three-day reporting period, sum units by product and divide by 3. Include days without sales after checking that the reports are complete.
Clean up and summarize data
How do I rank scores within each group without gaps after ties?
Give tied scores the same rank, then continue with the next number. Build a list of score levels for each group and use it to calculate a dense rank.
Clean up and summarize data
Import transaction rows without the total at the bottom
Keep the total row out of your import so it is not counted again. Set Last cell to the end of the transaction rows and check the loaded data.
Clean up and summarize data
Filter by a hidden field and export selected columns
Filter rows by Account, then hide Account and Owner from the output. Keep the source condition while exporting five nonadjacent columns.
Clean up and summarize data
Remove empty rows that still contain a filename
Remove rows containing only a source filename by checking the required ID column. Keep valid records even when their amount is zero.