Excel continuous lottery

An ingenious and simple method can be solved by formula. Suppose there are 10 people.

1, A 1:A 10 Input formula =rand ()

2. Enter the formula B 1 = rank (A 1, $ A $ 1: $ A $ 10) in B 10 and drop it down to B 10.

3. Enter 1- 10 in E10.

4. Enter a name in F 1:F 10.

5. Enter the formula C 1 (B 1, $ e $1:$ f $10,2,0) and drop it down to C 10.

6. Start and press F9, then release and stop. No other operation is required. If you don't want others to see the numbers in the ABEF column, just change the font to white.