This video shows how to set up an Excel worksheet to randomly pick from a list of items but never pick the same item twice. Dealing playing cards from a deck of 52 is the scenario used. The RAND, ROUNDUP, INDEX, and RANK functions are described, as well as conditional formatting.