Simulation of a random lottery system in the Excel2013 table

Statistics of various areas of the company's personnel situation, the following to draw a person, as a lucky audience, to give material rewards. Of course also can not have a trick, otherwise will cause disobedience, here we will use Rand random function, the following is I do a lottery simulation system.

Example Tutorial

① open Excel, the list of people involved in the lottery has been made and we enter directly into the F2 cell: =indirect ("D" &int (RAND () *13+2))

The meaning of ② formula I will explain later, enter press, get a person's name: Bowen.

③ Select the A:d column, click the menu bar-conditional formatting-new rule option.

④ Select the last rule type, use the formula to determine the cell to format, enter the formula: = $D 1= $F $, click Format button.

⑤ sets the cell format, which is the actual way the winning person is in the list, to distinguish it from others.

⑥ finished, as Evergrande won the Asian Championship, Huang Boven Award. We press the F9 key to refresh and the lottery will be again.

Formula description

The INT function returns a random integer of 2-14, and the D concatenation returns the random cell between D2:D14, and finally, indirect returns the name of the random cell.