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
Bookmarks