Closed Thread
Results 1 to 8 of 8

Creating random numbers for bingo games

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    Sandhurst, Berkshire, England
    MS-Off Ver
    365
    Posts
    3

    Creating random numbers for bingo games

    I host bingo events for charities as a volunteer and I would like to use an electronic version of the number generator.

    Is there a formula where you press a key and a random number between 1 and 90 (inclusive) appears and there are no duplicates?

    Secondly is it possible to show the chosen numbers in a 10 by 9 matrix? The second part to my request will be a bonus and not a necessity.

    Thank you.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Creating random numbers for bingo games

    Hi,

    I've helped someone with a similar question recently.
    See this thread : http://www.excelforum.com/excel-form...ml#post4164146, it might help you.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Creating random numbers for bingo games

    See attached.

    Here is code:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are happy with my response please click the * in the lower left of my post.

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Creating random numbers for bingo games

    Maybe :

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Creating random numbers for bingo games

    Here's another option
    Please Login or Register  to view this content.
    Last edited by alansidman; 09-06-2015 at 10:36 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Hi ! Try this easy demonstration !


    Paste this code to worksheet module :

    PHP Code: 
    Sub DemoB()
        Const 
    109
        Randomize
        M
    % = R
        VA 
    Evaluate("TRANSPOSE(ROW(1:" "))")

        For 
    N% = M To 2 Step -1
            P
    % = Fix(Rnd * (1)) + 1
            T
    % = VA(P): VA(P) = VA(N): VA(N) = T
        Next

        With Cells
    (1).Resize(RC)
            For 
    1 To M:  .Cells(N).Value VA(N):  Next
        End With
    End Sub 
    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
    Last edited by Marc L; 09-06-2015 at 11:37 PM. Reason: optimizing …

  7. #7
    Registered User
    Join Date
    12-11-2018
    Location
    De Aar, South Africa
    MS-Off Ver
    2016
    Posts
    1

    Re: Creating random numbers for bingo games

    Is it possible to make a hyperlink to show the called number automatically on say for instance on a projector screen, so that the players can see the number that was called?

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Creating random numbers for bingo games

    Hi DarzWS & Welcome to the Forum,

    Could you please start your own thread for this question, and by all means, link to this thread if necessary?
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] creating and re-creating 'random' numbers from a specific seed that can be recreated
    By OberonViking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2014, 04:13 PM
  2. Replies: 2
    Last Post: 01-21-2014, 09:42 PM
  3. Help needed to make game with bingo random qualities
    By frednufc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2013, 07:01 PM
  4. Creating random numbers that add up to a specific number
    By PapaCheese in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 07:00 PM
  5. Replies: 4
    Last Post: 05-15-2010, 06:57 PM
  6. Creating Random numbers in Excel problem
    By mrosendal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2008, 08:37 AM
  7. Create random number bingo cards with Excel
    By teachertolawyer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-15-2005, 07:05 AM
  8. creating random numbers
    By pikachiu132 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2005, 01:55 AM

Tags for this Thread

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