MUO on MSN

Excel's dynamic array functions made me realize I'd been solving problems the hard way for years

Turns out half my old formulas were just dynamic arrays in disguise, written the long way.
TechRepublic

How to create a sorted unique list in an Excel spreadsheet

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula. Lists are a fundamental part in almost any Microsoft Excel ...