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.
PC World

Use INDEX and MATCH for simple database queries in Excel

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...