Free Excel Formula Finder
Describe what you want your spreadsheet to do in plain English — get the matching Excel formula pattern, an example, and what it does.
Matching formula patterns will appear here. Describe what you need and click Find Formula.
How does this Excel formula finder work?
This is a static reference tool: it matches keywords in your description against a lookup table of the most common Excel formula patterns — lookups, conditional sums and counts, date math, and text extraction — and shows you the formula shape, a worked example, and a plain-English explanation.
It won't plug in your actual column names or handle a genuinely custom formula, but for the requests that come up again and again ("look up a value," "sum if a condition is met," "how many days between two dates," "pull text out of a cell") it gets you the right starting formula immediately.
For a formula built around your actual sheet — real column names, real edge cases — the AI Excel Formula Generator prompt pack on KissMySkills gives Claude or ChatGPT the framework to reason through it with you.
Like this free tool? Get the full Claude skill.
A ready-to-load skill that does this and far more — 290+ roles for Claude & ChatGPT.