How-To Geek on MSN
I stopped overusing IF in Excel—and my formulas instantly became cleaner and faster
Modern Excel functions like IFS, SWITCH, XLOOKUP, SUMIFS, and LET replace most nested IF use cases.
I didn't realize how much time I spent on cleanups until regex let me stop.
Make data more insightful with free, online, collaborative spreadsheets. See plans and pricing Try for free See plans and pricing Try for free Microsoft 365 Copilot in Excel unlocks the latest AI ...
Customer stories Events & webinars Ebooks & reports Business insights GitHub Skills ...
If regex finds a match in source: Returns dynamic array including all matches against the indicated capture groups captureGroups, or all of capturing groups in the regex. If number of captureGroups is ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results