Here's one for you that I can't think how to do. Does it need code?
At our golf club, each week we have a random draw for a voucher to spend in the Pro shop. I would like to generate the winning numbers via excel. The trouble being that there can be various number of winners each week depending on how many entrants ( normally 4 though) and the winning numbers must be unique.
So what I need is to have two input cells, 1) for the top limit of randbetween or how many people took part and 2) how many winners to generate.
So for example if 1) was 40 and 2) was 3
3 unique random numbers would be generated between 1 and 40.
Does this need code? How can you stop duplicates?
At our golf club, each week we have a random draw for a voucher to spend in the Pro shop. I would like to generate the winning numbers via excel. The trouble being that there can be various number of winners each week depending on how many entrants ( normally 4 though) and the winning numbers must be unique.
So what I need is to have two input cells, 1) for the top limit of randbetween or how many people took part and 2) how many winners to generate.
So for example if 1) was 40 and 2) was 3
3 unique random numbers would be generated between 1 and 40.
Does this need code? How can you stop duplicates?