Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results