MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulling Numbers Out Of A Hat


Posted by bucket on October 23, 2001 11:19 AM

I'm looking for a way to pull information from a list in a random order but not pull the same information again. An example would be like pulling numbers out of a hat. Once you pull that number its gone and you can't pull it again.

I've tried randbetween and rand but i can't figure a formula to do it all.


Posted by Mark W. on October 23, 2001 11:23 AM

It's called, "Sampling without replacement"

Enter RAND() into cells A1:A10. Enter the formula,
=RANK(A1,$A$1:$A$10), into cell B1 and copy down.
The values in column B are randomly ordered values
between 1 and 10 inclusive.

Posted by bucket on October 23, 2001 11:28 AM

Re: It's called, "Sampling without replacement"

Thanks this works just like I needed it to