43 prompts matching "INDEX"
I need to look up values in Excel using multiple conditions. My dataset has colu...
Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...
Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...
Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...
I have two Excel sheets: my bank statement transactions and my internal accounti...
Act as a database performance engineer with deep SQL optimization expertise. Hel...
I want a chart that always shows the last 12 months of revenue — so when I add M...
Build an Excel variance analysis report comparing Budget vs Actual for revenue a...
Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...
I want to build a sales dashboard in Excel that updates automatically when I pas...
I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...
The market is down [X%]. I have [POSITION]. I know intellectually I shouldn't se...
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
I have a slow query and I'm about to add an index. Before I do, help me think it...
Act as an Excel performance specialist. I will describe a workbook that has grow...
Act as a financial modeler reviewing my workbook. I have a model that runs base/...
Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...
I'll name an investing or finance concept I half-understand (compounding, divers...
You're a commercial counsel reviewing a vendor contract on my behalf — but expla...