Excel gurus love to tell you, "Always format your data as a table." While that's usually solid advice, it's not always the best move. In some scenarios, a simple range outperforms a table entirely.

Whether you're choosing an employee of the month, picking giveaway winners, or assigning tasks, Excel is the perfect tool for a bias-free draw. These simple formulas allow you to generate a single ...