ChatGPT Prompts for Excel

I need an Excel formula for this task:

**Goal:** {{what_you_want_to_calculate}}
**Data layout:**
- Column A: {{column_a_description}}
- Column B: {{column_b_description}}
- Column C: {{column_c_description}}
**Data starts at row:** {{start_row}} (e.g., row 2, with headers in row 1)
**Total rows:** approximately {{row_count}}

**Edge cases to handle:**
- {{edge_case_1}} (e.g., "blank cells should be skipped")
- {{edge_case_2}} (e.g., "duplicates should return the first match")

Provide:
1. The formula
2. A brief explanation of how it works
3. Paste it into cell: {{target_cell}}

Use the simplest function that works. Prefer INDEX-MATCH over VLOOKUP. If XLOOKUP is available (Excel 365), mention that as an alternative.

Write a VBA macro for Excel that does the following:

**Task:** {{describe_the_automation}}
**Sheet(s) involved:** {{sheet_names}}
**Range:** {{range}} (e.g., "A1:D500" or "Column A, all rows with data")
**Trigger:** {{trigger}} (e.g., "button click", "workbook open", "cell change")

Step-by-step workflow:
1. {{step_1}}
2. {{step_2}}
3. {{step_3}}

Requirements:
- Include error handling (On Error GoTo)
- Add comments explaining each section
- Show a message box when complete with a summary
- Handle the case where the sheet or range is empty

Format the code so I can paste it directly into the VBA editor (Alt+F11 > Insert > Module).

I have messy data in Excel that needs cleaning:

**Column:** {{column}} (e.g., "Column B, rows 2-1000")
**Current format (messy):** {{messy_format}}
Example messy values:
- "{{example_1}}"
- "{{example_2}}"
- "{{example_3}}"

**Desired clean format:** {{clean_format}}
Expected output for the examples above:
- "{{clean_1}}"
- "{{clean_2}}"
- "{{clean_3}}"

Provide:
1. A formula I can put in an adjacent column to clean each row
2. If the formula is complex, break it into helper columns
3. If Power Query would be better for this scale, show that approach too

My Excel version: {{version}} (e.g., "Excel 365", "Excel 2019")

Help me create a pivot table in Excel:

**Raw data structure:**
| Column | Description | Example values |
|--------|-------------|----------------|
| {{col_a}} | {{desc_a}} | {{examples_a}} |
| {{col_b}} | {{desc_b}} | {{examples_b}} |
| {{col_c}} | {{desc_c}} | {{examples_c}} |

**Analysis question:** {{what_you_want_to_know}}

Tell me:
1. Which field goes in Rows, Columns, Values, and Filters
2. What aggregation to use (Sum, Count, Average, etc.)
3. Any calculated fields I should add
4. Recommended chart type to visualize the result
5. Step-by-step instructions to set it up

Set up conditional formatting rules for my Excel sheet:

**Range:** {{range}} (e.g., "A2:F500")
**Data description:** {{what_the_data_represents}}

I want to highlight:
1. {{rule_1}} (e.g., "cells in Column C > 1000 → green background")
2. {{rule_2}} (e.g., "cells in Column D with text 'Overdue' → red text, bold")
3. {{rule_3}} (e.g., "entire row where Column E is blank → yellow background")

For each rule, provide:
- The exact steps in Excel (Home > Conditional Formatting > ...)
- If a custom formula is needed, provide the formula
- The order the rules should be applied (priority matters)

Also flag if any rules might conflict with each other.

I'm building an Excel dashboard. Help me create the summary formulas.

**Data sheet:** "{{data_sheet_name}}" with columns:
{{describe_columns}}

**Dashboard metrics I need:**
1. {{metric_1}} (e.g., "Total revenue this month")
2. {{metric_2}} (e.g., "Top 5 products by units sold")
3. {{metric_3}} (e.g., "Month-over-month growth %")
4. {{metric_4}} (e.g., "Count of orders by status")

For each metric, provide:
- The formula (using SUMIFS, COUNTIFS, LARGE, INDEX-MATCH, etc.)
- Where to place it on the dashboard sheet
- How to make it dynamic (auto-update when new data is added)

Use named ranges or structured table references where appropriate. My data is in an Excel Table named "{{table_name}}".