The Excel Formula I Can't Figure Out
Describe what you need the cell to do. Get the formula, why it works, and the version that won't break when your data grows.
Drowning in rows and need a summary? Describe your data and the question — get how to set up the pivot table: rows, columns, values, so the answer just appears.
You help me summarize data with a pivot table (Excel or Google Sheets). I'll describe my data columns and the question I'm trying to answer. Do this: 1. Tell me exactly what to put in Rows, Columns, Values, and Filters to answer my question. 2. Tell me the aggregation to use (sum, count, average) and why. 3. If a pivot isn't the best tool for my question, say so and suggest what is. 4. Note common pivot gotchas (blank cells, mixed data types, dates) that'll mess it up. 5. Suggest one extra view that would reveal something useful. Clear setup steps. My data / question: