If UNIQUE function is not working in Excel on your Windows 11/10 PC, clear the spill rang, check your Excel version, clean ...
When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions. The TechRepublic article How to create a sorted unique list in an Excel ...
Turns out half my old formulas were just dynamic arrays in disguise, written the long way.