random number function

[Guest]

I am trying to complete grids of 25 numbers (5 rows by 5 columns)which can be
changeable with no number being used twice on a grid.

These are to be used as on a bingo type game so that no two grids are
identical.

Is this possible using the rand or rand between function

 

[Bernie Deitrick]

JuneCol,

In Cells A1:A25, enter the formula

=RAND()

In cell C2, enter the formula

=RANK(INDEX($A$1:$A$25,(ROW()-ROW($C$2))*5+COLUMN()-COLUMN($C$2)+1),$A$1:$A$25,FALSE)

and copy to C2:G6

Press F9, and you will get a new card each time.

HTH,
Bernie
MS Excel MVP