Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Influencing Data | Excel Discussion (Misc queries) | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |