random number function
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 |
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 |
All times are GMT +1. The time now is 12:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com