Find the right formula
You know what you want, not which function does it. Choose the intention, give your cells: the formula is written in your Excel's language, and explained step by step.
What this tool does
- About twenty common intentions: look up, count and add up by criteria, flag duplicates, extract a first name, date gaps, percentage changes.
- Ranges locked with $ when the formula is meant to be copied down.
- The XLOOKUP version for Excel 2021 and Microsoft 365, or INDEX and MATCH for every version.
- An empty cell rather than an error, in one click, when the calculation can fail.
What it does not do: The intentions are the most common ones; a rarer need still means combining functions yourself. No artificial intelligence: formulas are written by rules, always the same.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Explain a formula : An inherited formula spelled out step by step, with its pitfalls.
- Translate a formula : VLOOKUP to RECHERCHEV, commas to semicolons: the formula moves from one Excel to the other.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- Formula audit : Errors, hard-coded values, formulas that stand out: what to check in a model.
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.