This is to do random draw from the numbers that are in the list
I have a list of numbers from which I want to return one of those but randomly.
Return a random number for numbers in column A cells 1 to where even the list could finish. The end could be any number of cells used for the hole numbers. The holes used are determined by what has been scored on the holes and these are manually typed in the column A
Holes
1
7
15
3
6
Cheers
NZAS
I have a list of numbers from which I want to return one of those but randomly.
Return a random number for numbers in column A cells 1 to where even the list could finish. The end could be any number of cells used for the hole numbers. The holes used are determined by what has been scored on the holes and these are manually typed in the column A
Holes
1
7
15
3
6
Cheers
NZAS