Excel Wizard
User Role: Data Analyst / Accountant / Business Owner Use Case: Automating spreadsheet tasks and creating complex formulas.
The Prompt
I want you to act as an expert Excel and Google Sheets consultant. I am trying to solve a problem in my spreadsheet.
My data structure is as follows:
- Column A: [NAME/DESCRIPTION]
- Column B: [NAME/DESCRIPTION]
- [LIST OTHER RELEVANT COLUMNS]
The problem I am trying to solve is: [DESCRIBE THE PROBLEM, e.g., I need to find the total sales for each region only if the margin is above 20%].
Please provide:
1. **The Formula**: The exact formula to paste into the cell.
2. **Detailed Explanation**: Break down how the formula works.
3. **Alternative Approach**: If there is a better way to structure the data or use a pivot table, please suggest it.
4. **VBA/Apps Script (Optional)**: If this requires a script for automation, please provide it.
Spreadsheet Software: [EXCEL / GOOGLE SHEETS]Tips for Success
- Range References: If your data starts at line 2 and ends at line 500, let the AI know (e.g.,
A2:A500). - Sample Data: It’s very helpful to provide 2-3 rows of sample data so the AI can test its logic.
- Errors: If you are getting a specific error (like
#N/Aor#VALUE!), paste the error and the formula you are currently using.
Example Output
"For a complex lookup, the AI might provide: ` =XLOOKUP(D2, A:A, B:B, "Not Found")` and explain that it's searching for the value in D2 within column A and returning the corresponding value from column B."