Excel #8 – Making a Bingo Card Using Only Formulas with Dynamic Array Functions

Five years ago I made a Bingo card that used only formulas.

https://dhexcel1.wordpress.com/2015/03/31/bingo/

The process of generating non-repeating random numbers using only formulas was

developed at excelxor.com. I used that concept to make the Bingo card with a formula of

the following type:

=SMALL(IF(FREQUENCY($A3:$A$8,ROW(INDIRECT(“2:15”))-1)=0,ROW(INDIRECT(“2:16”))-1),RANDBETWEEN(1,15-COUNTA(A3:$A8)))

However, using the new dynamic array functions, this solution becomes much simpler.

=SORTBY(SEQUENCE(15),RANDARRAY(15))+(15*(COLUMN()-1))

You can download the Excel file containing both the new and old versions by clicking this link:

NewBingo

Stay tuned for more!