Use-case finder

Tell us your goal — we'll suggest the formula

No need to know whether the answer is XLOOKUP, FILTER, or SUMIFS. Type what you're trying to accomplish in everyday language. The finder ranks suggestions by how well they match your description.

value lookup conditional sum conditional count filter rows unique list split text join text if/else many conditions age running total clean text random number ranking percent of total
How this is different

Why a goal-first finder beats a function index

Most Excel references are alphabetical lists of functions. They work great when you already know the function name — but useless when you're stuck describing the problem. The finder above flips that: you describe the problem, it picks the function. It also nudges you toward the modern, dynamic-array way of solving the problem (XLOOKUP over VLOOKUP, FILTER over autofilter copy-paste, SCAN over dragged running totals).