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
"junecol" wrote in message
...
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
|