Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to keep random number from changing using RANDBETWEEN? | Excel Worksheet Functions | |||
Number range function | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
clock | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions |