+ Reply to Thread
Results 1 to 11 of 11

create my own bingo game

  1. #1
    Registered User
    Join Date
    10-23-2006
    Posts
    17

    create my own bingo game

    Hi,

    I've tried to create my own bingo game sheet but am not getting the expected result. Hope you can help me with this small dilemma.

    I got the random number part down but am having problem making it unique.

    B - numbers 1-15
    I - numbers 16-30
    N - numbers 31-45
    G - numbers 46-60
    O - numbers 61-75

    The "B" column will generate random numbers from 1 through 15 but very often that number is not unique in that column. Could you help me with the solution?

    Thanks a bunch!

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523
    Hi there,

    See if this UDF by Dave Hawley and J.E. McGimpsey does the trick.

    HTH

    Robert

  3. #3
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    How are you generating you random numbers?
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  4. #4
    Registered User
    Join Date
    10-23-2006
    Posts
    17
    Hi there!!!
    Thanks for the prompt replies!!!

    I've tried the randomlotto....but it's generating the random numbers all in 1 cell. How do I spread it through 5 cells? The card is 5cells by 5 cells.

    This is the formula I have on the cell...
    B column =RAND()*(15-1)+1
    I column =RAND()*(30-16)+16
    etc.

    Thanks!

  5. #5
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523
    Hi there,

    No, it's beyond my capabilities to try and tinker with anything Dave has written.

    Have a look at these suggestions, particularly the "RandomNumber" macro.

    HTH

    Robert

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572
    The code below will generate a bingo card each time it is run:

    Please Login or Register  to view this content.
    Ben Van Johnson

  7. #7
    Registered User
    Join Date
    10-23-2006
    Posts
    17
    Hi, I'm back.
    ...been tinkering with the information you sent me and reading the forum...a wealth of knowledge to absorb and play with.

    With my limited knowledge, I couldn't tweaked the code to work for me on the random number, Robert. I'm sure it's me and not the code.

    Ben, I was able to generate the random numbers using your code but am spending a lot of time formatting it. I'm trying to generate a bunch of cards so I can print them out. Ideally, I'd like to click on a button and 6 cards are generated with new numbers...similar to the xbingo game on this link by Dave

    http://www.cpearson.com/excel/g

    Until this is achieved, I'm generating and formatting the cards manually as seen on the attachment.

    Thanks for all your help. I'm learning quite a bit browsing through here.
    Attached Files Attached Files

  8. #8
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572
    Please try the attached file. I have modified the code to generate forms as per your example.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    05-29-2012
    Location
    sINGAORE
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: create my own bingo game

    Hi Guys,

    Appreciate your efforts for building and running this web-forum for people like us. I cam across a situation where need excel guru's help. Below is my question.

    I have a question here for Bingo...

    The bingo I want is in this format ...

    B I N G O
    Group1 Group3 Group4 Group5 Group6
    Group2 Group1 Group4 Group5 Group6
    Group2 Group3 Group1 Group5 Group6
    Group2 Group3 Group4 Group1 Group6
    Group2 Group3 Group4 Group5 Group1

    And data is ...
    Group1 Group2 Group3 Group4 Group5
    1 21 41 61 81
    3 23 43 63 83
    2 22 42 62 82
    5 25 45 65 85
    9 29 49 69 89
    6 26 46 66 86
    8 28 48 68 88
    11 31 51 71 91
    12 32 52 72 92
    20 40 60 80 100
    16 36 56 76 96
    13 33 53 73 93
    19 39 59 79 99
    17 37 57 77 97
    18 38 58 78 98

    Now I want to create unique code by merging both group's unique numbers
    - Code should have 4 unique numbers from Group B and 1 unique number from Group A (A set of total 5 unique numbers from both group)

    Can you guys help me to tell how many unique numbers can be generated and how you could do that (Formula!!)

    Regards
    Pranav
    [email protected]

  10. #10
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: create my own bingo game

    Hello and welcome to the forum.

    Please do not post in another member's thread but instead start your own thread. If this thread is relevant to your question, then feel free to provide a link to it.

    Thank you.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  11. #11
    Registered User
    Join Date
    05-29-2012
    Location
    sINGAORE
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: create my own bingo game

    Thanks Abousetta.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1