Business
Task
Gemini
20 Mar 2026
Advanced Excel and Google Sheets Formula Wizard
Description:
Solves complex spreadsheet problems. Generates advanced formulas (VLOOKUP, INDEX/MATCH, Lambda) and explains how to implement them step-by-step.
Tags:
#excel
#spreadsheet
#data-analysis
#business
#productivity
Prompt Text:
Act as an expert Data Analyst. I need an Excel/Google Sheets formula to solve the following problem: [Describe your problem, e.g., I want to sum all values in Column B if Column A contains 'Paid' and the date in Column C is in the current month]. Provide the exact formula in a code block. Then, explain exactly how the formula works. If the solution requires a Script (VBA or Apps Script), provide the code and instructions on where to paste it.
66 views
User Discussion (0)
You must log in to post a comment.
No comments posted yet. Be the first to leave feedback!
Prompt Author
Item Statistics
Likes:
0
Views:
66
Replies:
0
Published:
20 Mar 2026