+ Reply to Thread
Results 1 to 2 of 2

How to match 2 random numbers from a list of numbers already chosen

  1. #1
    Registered User
    Join Date
    10-15-2020
    Location
    Bridgwater England
    MS-Off Ver
    5
    Posts
    1

    How to match 2 random numbers from a list of numbers already chosen

    Hello
    I am a complete newbie to google spread sheets so bear with me.
    As a fund raiser for a local under 12s football club there is a weekly lotto draw. 15 pairs of numbers are picked from 1 to 30 chosen by a person and once a week 2 random numbers are drawn between 1 and 30.Whoever matches up with the numbers drawn wins the draw . The numbers chosen also count each way so if 9 and 19 was randomly drawn this would win and also 19 and 9 would count.
    Is there a way of using google spread sheet to match numbers randomly drawn against name of person who may have picked those numbers , instead of going through lots of envelopes checking the 2 numbers against numbers already picked.

    Regards
    Adrian

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    Re: How to match 2 random numbers from a list of numbers already chosen

    Hi Adrian, hopefully this will give you a bit of a start to play with.

    https://docs.google.com/spreadsheets...BA9cFy/pubhtml

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to seperate numbers that match 2 numbers from a list.
    By notmyday in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2016, 07:51 AM
  2. how to seperate numbers that match 2 numbers from a list.
    By notmyday in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2016, 07:30 AM
  3. i want to match random letters A to J with numbers
    By msa969 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-20-2016, 05:41 PM
  4. [SOLVED] adding text after the numbers that is chosen by the drop down list
    By Bobby82 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2014, 09:23 PM
  5. [SOLVED] Macro to pull 6 random numbers from a list of numbers.
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2014, 07:07 AM
  6. [SOLVED] Random pairs of numbers for team match-ups
    By dubcap01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2014, 06:39 AM
  7. Generating a list of Random numbers of random length...
    By Growl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 12:10 PM

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