Business
Task
Gemini
27 days ago
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
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.
13 views
About the author
Statistics
Likes
0
Views
13
Comments
0
Published
20 Mar 2026