How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

Problematics | Dollars and paise

The Problematics reader was born in 1924. Her sister was born in 1912 (age 12 in 1924, matching the last two digits 12). Their grandmother was born in 1862 (age 62 in 1924, matching the last two ...

Our Top 10 High Growth Dividend Stocks - January 2026

We use our proprietary models to rate both quantitatively and qualitatively, and select the top 10 names from an initial list ...

5 Power Query Custom Column Tips That Save Time : Master Nulls, Errors & Types

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...
How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...