Free toolRuns in your browser · no sign-up

Your inputs

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 - one of 2,400+ skills, prompts and agents for Claude & ChatGPT.

Browse all skills → All prompts

More free developer tools

All free tools →

Questions

Is the Excel Formula Finder free?

Yes. Use it on this page as often as you need, with no sign-up.

Do I need the app to keep using this page?

No. This page stays free and keeps working without an account.

Can I get my money back?

Yes. The first charge of a paid plan has a 30-day money-back guarantee.