Influencing Random Numbers
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 dont 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 |
Influencing Random Numbers
=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 --------------- Jacob Skaria "Art W" wrote: 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 dont 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 |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com