# Solve an Excel or Google Sheets problem

Gets you the right formula, pivot, or approach — with an explanation you can reuse.

- Topic: Data & Analysis
- Framework: RCTF
- Level: Standard
- Tags: Data & Analytics, Analyze, Explain & Teach, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/solve-an-excel-or-google-sheets-problem

## Prompt

```text
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]
```

## What to fill in

- PASTE

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.