Excel questions (bingo 1-60 numbers)

[Legacy 510990]

Sorry to bother you. I really need help
I want to make an Excel bingo file from 1-60 numbers. includes 6 columns and 15 rows
column 1: from 1 to 9
Column 2: from 10 to 19
Column 3: from 20 to 29
Column 4: from 30 to 39
Column 5: from 40 to 49
Column 6 : from 50 to 60
How can I get different values every time I press F9?

 

[Peter_SSs]

Tôi có thể tải file excel trên được không?

As I said before ...

Please post in English only in this forum per the forum's outline

Can I download the above excel file?

Use this button to copy and paste into a blank worksheet

 

[Legacy 510990]

I have a little problem: row 14 and row 15 only have 3 numbers

 

[Anonymous1378]

I have a little problem: row 14 and row 15 only have 3 numbers

Isn't that because you moved the 1 from I1 to M1?

 

[Peter_SSs]

Isn't that because you moved the 1 from I1 to M1?

Did you mean to I1 from M1?

 

[6StringJazzer]

Can I download the above excel file?

It is not a file, it is a range of cells copied to code to display it here. You can click the "copy" icon (in the upper left corner between A and 1) and then Paste to a blank worksheet.

 

[Peter_SSs]

You can click the "copy" icon (in the upper left corner between A and 1) and then Paste to a blank worksheet.

As I mentioned in post 11.

 

[Legacy 143009]

The best forum thread so far about this very topic:

UK Bingo cards

Apologies for asking for so much help on my very first post here. I've been searching all over for a solution to be able to produce a UK style bingo card within Excel using formulas or VBA, but so far have only found code that's capable of producing singular games rather than a set of 6. I've...

www.mrexcel.com

 

[6StringJazzer]

As I mentioned in post 11.

It's funny, I had this thread open in a tab and then hit F5 to refresh it and did not see that post. I did not see it until after I made my post then all of a sudden all the newer posts were visible. Not sure what happened.

 

[Peter_SSs]

Not sure what happened.

Fair enough. I have had that sort of thing happen too.

 

[6StringJazzer]

Sorry to extend this diversion but I think it's because when I refreshed, it was still on the first page of posts but by then posts had flowed onto a second page. So of course my post went onto the second page and then I saw the newer posts.