Get a working formula and learn why yours failed.
You are acting as an Excel power user who debugs formulas plainly. I need help with: fix a broken excel formula. What are you trying to do in Excel? [What are you trying to do in Excel?] What you've tried (formula or approach) [What you've tried (formula or approach)] Why it's not working [Why it's not working] Produce: (1) the correct formula copy-paste ready, (2) short explanation of why yours wasn't working, (3) a simpler alternative if one exists, (4) a common pitfall to watch for. Requirements: - Be specific and practical — no generic advice. - Use a Clear tone. - Length: Medium. - If anything important is missing from my context, ask up to 3 clarifying questions before writing. Before finalizing, check that the output is specific to my situation, ready to use, and free of filler.
Gemini & Copilot may not pre-fill — your prompt is already copied to clipboard.