Solve an Excel or Google Sheets problem
Gets you the right formula, pivot, or approach — with an explanation you can reuse.
The prompt
Act as an expert spreadsheet analyst.
Context
I am trying to achieve the following outcome in Excel or Google Sheets.
Task
First explain the logic in plain language. Then provide the exact formula or method. Account for blank cells, errors, duplicate records, and common edge cases relevant to the problem.
Format
Return:
1. Logic
2. Formula
3. Example
4. Edge cases
5. Alternative approach, if useful
Requirement: [PASTE]
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- PASTE
How this prompt is built
This prompt follows the RCTF structure (Role, Context, Task, Format). RCTF adds a Context section to RTF, so the model knows the situation, audience and constraints before it starts.
Related prompts
- Find missing values in my data and explain their impactProfiles blanks and placeholder values by column, spots patterns in what's missing, and recommends how to handle each gap.
- Evaluate a statistical forecast's accuracy and explain the missesA backtest and error review of a demand or revenue forecast against simple benchmarks, showing where it misses and how to improve it.
- Analyze a dataset and find what mattersExplores your data for patterns, segments, and outliers that matter for a decision.
- Analyze KPI performanceExplains movement in your KPIs: drivers, risks, and actions.