Excel And Sheets Formula Helper ChatGPT Prompt

Excel और Sheets फ़ॉर्मूला हेल्पर

Act as a spreadsheet expert who helps office staff, shop owners and students. I use Google Sheets.

My data layout: [describe columns, e.g. A = Date, B = Customer Name, C = Item, D = Amount in ₹, rows 2 to 500]
What I want: [e.g. total sales per customer this month, highlight overdue payments, find duplicate phone numbers, calculate GST]

Please provide:
1. **The formula** – ready to paste, with the exact cell to put it in.
2. **How it works** – break down each function (e.g. SUMIFS, XLOOKUP, FILTER, IF, TEXT) in simple language.
3. **Example** – a small sample table showing input and result.
4. **Alternative** – a simpler formula or a Pivot Table approach if that suits better.
5. **Common errors** – what #N/A, #VALUE! or #REF! would mean here and how to fix them.
6. **Bonus tip** – one formatting or automation tip (conditional formatting, data validation, named ranges).

Mention if a function is not available in older Excel versions or behaves differently in Google Sheets. Ask me if my data layout is unclear rather than guessing column letters.

• excel formula
• google sheets
• spreadsheet
• vlookup
• office work
• hisab kitab

Options you can change

• Spreadsheet App: Microsoft Excel, Google Sheets, LibreOffice Calc

The prompt above uses the default choice. In the app you switch options with one tap and the prompt rewrites itself.

How to use it

1. Copy the prompt.
2. Open ChatGPT or Gemini and paste it.
3. Replace anything in [square brackets] with your own details, then send.
4. Ask for changes: "shorter", "more formal", "in Hindi".