selecting unique and random values

[kvp0431]

I am trying to create a customized bingo card using Excel. I have a
list of 50 different names that should be randomly filled in a Bingo
card 5 rows by 5 columns.

Q) Is there a function or macro that anyone has worked on that
addresses what I am trying to do?

Thanks.

 

[J.E. McGimpsey]

One way:

Put your list in a column, say J1:J50. In K1 enter

=RAND()

and copy down.

In A1 enter

=INDEX($J$1:$J$50,ROW()+5*(COLUMN()-1))

and copy down to A5, then copy A1:A5 across to E1:E5.

Select a cell in J1:K50 and choose Data/Sort and sort on column K.
You'll then have randomized names in A1:E5. Sort again to get a
different random order.