Influencing Random Numbers

[Art W]

Hello Everyone:

I am trying to create random numbers between 1 and 100. I am also trying to
influence the output by referencing either a cell or a range. I have been
working on this problem for a long time. I think I am looking for something
like the formulas below, but they don’t work. Hopefully it will give you an
idea of what I am trying to do.

=RANDBETWEEN((1,100), A1))
=RANDBETWEEN((1,100),SEEDS))

Thanks

Art

 

[Jacob Skaria]

=RANDBETWEEN(1,100) returns a radom number between 1 and 100

"I am also trying to influence the output by referencing either a cell or a
range"

If you are trying to link to your data in Col A (A1 to A1000) and pick 100
random samples from A1:A1000

--In B1 enter the below formula and copy down upto B1000
=RAND()

--In C1 enter the below formula and copy down to C100 (your sample list)
=INDEX($A$1:$A$1000,RANK(B1,$B$1:$B$1000))



If this post helps click Yes