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.
How-To Geek on MSN
How to randomize rows in an Excel table without scrambling your data
Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...
Handle millions of rows by loading queries into Power Pivot, building relationships, and creating measures for fast variance ...
Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...
Today’s investors have come to know too well that the market can be unpredictable, highlighting the importance of formulating a sound retirement portfolio. While the 4% rule is a widely accepted ...
Newcastle pulled off a dramatic comeback, defeating Leeds United in the final minute. The home side continues its climb up the league table.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback