Random Numbers

[nastyveg]

Hi, I need to create some bingo style cards. These are in a grid of 5 x 5 numbered 1 - 25 in random order.
I need to create 50 different bingo cards with numbers 1 - 25 but all in different sequences.
Can anyone help, I just can't crack it.

I hope it makes sense.

Any help would be great.

Thanks

 

[6StringJazzer]

Bingo cards are not 1-25. There are 15 numbers for each letter in BINGO. The columns are labeled "B" (numbers 1–15), "I" (numbers 16–30), "N" (numbers 31–45), "G" (numbers 46–60), and "O" (numbers 61–75).

Can you clarify what you need?

 

[Eric W]

If you are just looking for a random square of the numbers 1-25:

Book1 (version 1).xlsb
	A	B	C	D	E
1	3	25	23	20	9
2	2	8	6	11	4
3	17	16	1	12	22
4	21	19	15	10	5
5	13	18	14	24	7
Sheet10

Cell Formulas
Range	Formula
A1:E5	A1	=LET(a,SORTBY(SEQUENCE(25),RANDARRAY(25)),INDEX(a,SEQUENCE(5,5)))
Dynamic array formulas.

If you want 50 of these, you can use the formula 50 times, or print one, then F9 to recalculate, and print and repeat as needed. But it would probably be easier to do it via VBA.

 

[nastyveg]

Bingo cards are not 1-25. There are 15 numbers for each letter in BINGO. The columns are labeled "B" (numbers 1–15), "I" (numbers 16–30), "N" (numbers 31–45), "G" (numbers 46–60), and "O" (numbers 61–75).

Can you clarify what you need?

Hi, thanks for the reply. Our client as asked for a bingo style card. with numbers 1-25 randomly placed in a grid without repeat. The want 50 of these.

 

[6StringJazzer]

Then @Eric W has your solution in post #3.

 

[nastyveg]

Thanks for your help.
@Eric W thank you.

 

[felixstraube]

This would be a bingo card:

Book1
	A	B	C	D	E
2	B	I	N	G	O
3	2	30	32	53	75
4	4	27	31	58	66
5	10	18	45	56	74
6	14	19	44	54	67
7	1	16	33	47	72
Sheet1

Cell Formulas
Range	Formula
A3:E7	A3	=LET( num,75, n,SEQUENCE(num), sec,INT((n-1)/(num/5))+1+RANDARRAY(num,,0,0.9), DROP(WRAPCOLS(CHOOSECOLS(SORT(HSTACK(n,sec),2),1),num/5),num/5-5) )
Dynamic array formulas.

And this bingo "style" card with numbers from 1-25?:

Book1
	A	B	C	D	E
2	B	I	N	G	O
3	2	6	12	19	22
4	5	9	15	16	21
5	1	8	13	20	25
6	4	10	14	18	24
7	3	7	11	17	23
Sheet1

Cell Formulas
Range	Formula
A3:E7	A3	=LET( num,25, n,SEQUENCE(num), sec,INT((n-1)/(num/5))+1+RANDARRAY(num,,0,0.9), DROP(WRAPCOLS(CHOOSECOLS(SORT(HSTACK(n,sec),2),1),num/5),num/5-5) )
Dynamic array formulas.

but i guess @Eric W s response is what you need.

 

[nastyveg]

This would be a bingo card:

Book1
	A	B	C	D	E
2	B	I	N	G	O
3	2	30	32	53	75
4	4	27	31	58	66
5	10	18	45	56	74
6	14	19	44	54	67
7	1	16	33	47	72
Sheet1

Cell Formulas
Range	Formula
A3:E7	A3	=LET( num,75, n,SEQUENCE(num), sec,INT((n-1)/(num/5))+1+RANDARRAY(num,,0,0.9), DROP(WRAPCOLS(CHOOSECOLS(SORT(HSTACK(n,sec),2),1),num/5),num/5-5) )
Dynamic array formulas.

And this bingo "style" card with numbers from 1-25?:

Book1
	A	B	C	D	E
2	B	I	N	G	O
3	2	6	12	19	22
4	5	9	15	16	21
5	1	8	13	20	25
6	4	10	14	18	24
7	3	7	11	17	23
Sheet1

Cell Formulas
Range	Formula
A3:E7	A3	=LET( num,25, n,SEQUENCE(num), sec,INT((n-1)/(num/5))+1+RANDARRAY(num,,0,0.9), DROP(WRAPCOLS(CHOOSECOLS(SORT(HSTACK(n,sec),2),1),num/5),num/5-5) )
Dynamic array formulas.

but i guess @Eric W s response is what you need.

 

[nastyveg]

Thanks @felixstraube, this is great.