How-To Geek on MSN

Forget XLOOKUP: Why FILTER is better for extracting Excel data

The FILTER function extracts every matching record while XLOOKUP only returns the first result.

15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...
TechRepublic

How to generate random numbers with no duplicates in Excel

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...
Neowin

Microsoft adds Dynamic Arrays to Excel to make formulas more capable

Microsoft has announced some improvements to the way formulas work in Microsoft Excel, introducing a new capability called Dynamic Arrays, which was first announced last year, but only available to a ...
How-To Geek on MSN

How to use the REDUCE function in Microsoft Excel

Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...
Geeky Gadgets

Say Goodbye to Complex Excel Formulas : Meet the SCAN Function

What if you could solve intricate Excel problems with a single, elegant formula? Imagine replacing a web of complex, error-prone calculations with one streamlined function that handles it all. Enter ...
TechRepublic

How to use UNIQUE() to populate a dropdown in Microsoft Excel

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.