Ppt Phantom Making Lottery

Suppose your table structure is as follows

B.C.

The serial number of the extracted items is randomly selected.

ase 123

dfgt464

ds454

da356

hynh232

ahrt679

158ves

42 1gfg

kuy3545

4 12ghj

Please enter the formula = index (a: a, round (rand () * (Counta (a: a)-1), 0)+ 1) in the C2 cell.

Now, just enter the lottery serial number in cell B2, and then press Enter to display the randomly selected items in cell C2.

There is no limit to the number of items drawn in column A. ..