Random Function Excel - Ballot

Question

Hi,

I'm using the following formula

"=Rand()*(b-a)+a"

for a ballot.

I have 20 numbers, reach refers to a name for a lucky individual who is entitled for a prize. I want to ballot five people in total.

How can I exclude a number that has been balloted from the next round of balloting - ideally in the same spreadsheet?

So let's say first field where I enter the above code is 18, next field should pick a random number between 1 and 20 excluding 18 - is this feasible?

Thanks for your help.

Answer 1

Hi,

I'm using the following formula

"=Rand()*(b-a)+a"

for a ballot.

I have 20 numbers, reach refers to a name for a lucky individual who is entitled for a prize. I want to ballot five people in total.

How can I exclude a number that has been balloted from the next round of balloting - ideally in the same spreadsheet?

So let's say first field where I enter the above code is 18, next field should pick a random number between 1 and 20 excluding 18 - is this feasible?

Thanks for your help.

 

For a variety of options see

Select elements at random without repetition

http://www.tushar-mehta.com/excel/newsgroups/rand_selection/

Answer 2

Thank you - got it! Great help! Thanks!!!