random number generator

**thusarix** · 10-22-2011, 05:41 AM

i want to build a random number generator, that picks the numbers from which to generate from a list that i supplie, and i found this formula:


 =INDEX($B2:$B21,RANDBETWEEN(1,COUNTA($B2:$B21)),0)

the thing is that i need to generate numbers in 4 diferent cells, and i need them to be diferent

the attachment may be a little more clear.

**martindwilson** · 10-22-2011, 08:41 AM

just to pick 4 unique random from an unique list try this
for more rows try it this second way

**thusarix** · 10-22-2011, 08:55 PM

if i enlarge the arrays it doesnt work anymore

**martindwilson** · 10-23-2011, 05:04 AM

it does fine for me,enlarge how? follow the function to see what its doing adjust ranges as needed

**JAMURPHY** · 11-29-2011, 02:07 PM

I would like to create a Unique Random Number Generator in Excel including the numbers 1 through 100 in cells A1:J10; I need to have each number unique, so that any given number does not appear in more than 1 cell at any given press of the Calculate Now button.

Any Ideas?

Thanks,

**shg** · 11-29-2011, 02:18 PM

Welcome to the forum, JAMURPHY.

What you want is readily done in a variety of ways. Please take a few minutes to read the forum rules, and then start your own thred.

Thanks.

**darkyam** · 11-29-2011, 02:19 PM

Welcome to the forum, JAMURPHY. However, your post does not comply with rule #2. Please read the rules and then post your question in a new thread. Thanks.