Hi all l, I've been trying to create some UK rules bingo cards to play with the family during lockdown but have failed.
Does anyone have any experience in generating such a thing in Excel and if so wonder if you could help me produce it.
A UK rules bingo card consists of 6 tickets wi5h each ticket consisting of 9 columns and 3 rows. Each row in a ticket must have 5 numbers and 4 blank cells. Each column in a ticket must have a minimum of 1 number and maximum of 3 numbers. Column 1 only holds numbers 1 to 9, column 2 is 11 to 20 and so on until column 9 is 80 to 90.
Every number from 1 to 90 should appear once and only once across the 6 tickets that make up 1 game with no duplicates and no missing numbers.
I've attached a copy of a ticket which shows the rules I have stated above. Any help with this would be much appreciated.
Bookmarks