Skip to content
Codextroop Prompt Library

Excel

Excel Formula and a Clean Sheet

AI Tool: ChatGPTCategory: Data & Analytics

Get the formula, a sample table layout, and the error cases to watch for — in Excel or Google Sheets.

excelgoogle sheetsformulasspreadsheets

The Prompt

Help me solve this in a spreadsheet.

Tool: {{tool}}
What I am trying to calculate: {{goal}}
Columns I have:
{{columns}}
Example rows:
{{examples}}
Constraints: {{constraints}}

Deliver:
1. Recommended table layout (headers)
2. The formula(s) with A1-style references explained
3. A worked example using my sample rows
4. What breaks it (blanks, text-as-numbers, duplicates)
5. A Pivot / QUERY alternative if that is cleaner

Prefer simple formulas over nested wizardry unless {{goal}} requires it.

Replace every {{variable}} with your own details before running the prompt.

Variables to fill in

5 variables

{{tool}}required
Excel or Google Sheets.
{{goal}}required
What you want to calculate.
{{columns}}required
Existing column names.
{{examples}}
A few example rows.
{{constraints}}
No add-ins, must work on Excel 2016, etc.

Scroll to see every variable.

Best for

  • Operators
  • Finance
  • Students