Solve the following spreadsheet challenge:
[DESCRIBE WHAT YOU NEED TO CALCULATE/LOOKUP/TRANSFORM]
Data layout: [DESCRIBE YOUR COLUMNS AND SAMPLE DATA]
Tool: [EXCEL / GOOGLE SHEETS]
Provide:
1. The exact formula with cell references
2. Step-by-step explanation of how it works
3. How to drag/copy it correctly
4. Error handling (what if a cell is blank or has wrong data?)
5. A simpler alternative if the formula is complex
6. Named range suggestions for readability
If the task requires multiple formulas or a pivot table:
- Provide the complete setup steps
- Include helper columns if needed
- Suggest a dynamic solution (Tables, FILTER, QUERY) over static formulas
Solve the following spreadsheet challenge:
[DESCRIBE WHAT YOU NEED TO CALCULATE/LOOKUP/TRANSFORM]
Data layout: [DESCRIBE YOUR COLUMNS AND SAMPLE DATA]
Tool: [EXCEL / GOOGLE SHEETS]
Provide:
1. The exact formula with cell references
2. Step-by-step explanation of how it works
3. How to drag/copy it correctly
4. Error handling (what if a cell is blank or has wrong data?)
5. A simpler alternative if the formula is complex
6. Named range suggestions for readability
If the task requires multiple formulas or a pivot table:
- Provide the complete setup steps
- Include helper columns if needed
- Suggest a dynamic solution (Tables, FILTER, QUERY) over static formulas
How to use this prompt
Copy the prompt above and paste it into ChatGPT, Claude, Gemini, or any AI assistant. Replace the bracketed placeholders with your specific details.
Leave a Review
Tried this prompt? Let us know how it worked — your reviews help other users find the best prompts.