How-To Geek on MSN
How to randomize rows in an Excel table without scrambling your data
Master row randomization in Excel using the classic helper column method or the dynamic SORTBY function.
How-To Geek on MSN
How to pick a random name from a list in Excel
Select winners in Excel using classic INDEX formulas or modern CHOOSEROWS and TAKE combinations.
How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback