ashleygf
04-19-2015, 05:10 PM
Good Morning, I am attempting to develop a simple random draw spreadsheet for my local bowls club.
I would like help, if possible, with the following using Excel 2013.
In cells A1 .. A21 I will manually insert up to 21 random numbers (meaning any numbers up to 21 but not necessarily using all eg. omitting 3,5,10 19).
By means of a macro I would like to copy those numbers into say columns B and C. I would then like to sort all numbers so that A1 does not equal B1 or C1, A2 does not equal B2 or C2, A3 does not equal B3 or C3 etc.etc.
I have attempted the above but with no success and would appreciate any help.
Thanks and regards.
I would like help, if possible, with the following using Excel 2013.
In cells A1 .. A21 I will manually insert up to 21 random numbers (meaning any numbers up to 21 but not necessarily using all eg. omitting 3,5,10 19).
By means of a macro I would like to copy those numbers into say columns B and C. I would then like to sort all numbers so that A1 does not equal B1 or C1, A2 does not equal B2 or C2, A3 does not equal B3 or C3 etc.etc.
I have attempted the above but with no success and would appreciate any help.
Thanks and regards.