Making digital lottery tickets by Excel

Solution: use two auxiliary columns and add "auxiliary" columns to generate random numbers, and sort the random sequences to achieve the purpose of random extraction; Add an "order" column to "restore" the original recording order after the operation is completed.

Operation method:

As shown in the figure, adding two auxiliary columns (the yellow background part is the auxiliary two columns), =rand () can generate random numbers;

Sort the d column;

Copy the top 20 records and paste them elsewhere;

Sort the C column to restore the order of the original data;

Delete the second column.