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.
Hosted on MSN

I Build Lightning-Fast Lookup Formulas With These Excel Functions

Slow lookup formulas can kill productivity when working with large datasets. To cope with that, I've tested Excel's optimal lookup functions and their combinations for building lightning-fast formulas ...