How does Excel make a list of names?

Some time ago, many netizens consulted Bian Xiao Excel about the operation of making lists. Today, Bian Xiao specially shared the graphic tutorial of Excel random list, which I believe will be helpful to everyone.

List everyone's name in the table and make a chart.

Enter a function in the roll call box:

=INDIRECT(aRANDBETWEEN(3， 12))

This RANDBETWEEN(3, 12) means randomly selecting 3 to 12, and combining an A in front of it means A3 to A 12, which just corresponds to all cells in the name column. Placing an indirect outside means that the contents of cells A3 to A 12 are randomly extracted.

Fill it out and press Enter, then click F9 to draw randomly, or press F9 to simulate the lottery.

Above, I will share with you the operation content of making Excel random roll call table. More exciting information in deep space games.