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.
How-To Geek on MSN

How to use formula by example in Excel to generate complex formulas

I traded the static results of Flash Fill for dynamic formulas that update automatically.