Creates Excel formulas with step-by-step explanations
Help me with a formula in {platform} (Excel / Google Sheets).
Task: {task}
Data:
- Columns: {columns}
- Sample data: {example}
Provide:
1. **Formula** — ready to paste
2. **Explanation** — breakdown of each function in the formula
3. **Step-by-step walkthrough** — how the formula processes the data
4. **Alternative approach** — if there is a simpler way
5. **Common mistakes** — what to watch out for
0 copies
Variables
Replace these variables with your own values before using: