Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign number to correct range
I have a range of numbers representing a culmalative total for a population
e.g: 1 500 2 750 3 1000 I then generate a sequence of random numbers, e.g 250, 800 etc. So if I get 250 it should appear beside 1 (since it is less than 500), and if I get 800 it should appear beside 1000 ((since it is less than 1000). Anyway to do this? I have no problem with a solution that reads the random numbers generated and then assigns them to the correct position |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign number to correct range
There is a function RANDBETWEEN(Bottom#,Top#) which may be a part of
the Tool-Pack_AddIn, But that is what you need. With A1:A4 = 0, 500, 750, 1000 In Cell B2 enter =RANDBETWEEN(A1, A2) -- Copy down to B4 HTH "blinton25" wrote in message : I have a range of numbers representing a culmalative total for a population e.g: 1 500 2 750 3 1000 I then generate a sequence of random numbers, e.g 250, 800 etc. So if I get 250 it should appear beside 1 (since it is less than 500), and if I get 800 it should appear beside 1000 ((since it is less than 1000). Anyway to do this? I have no problem with a solution that reads the random numbers generated and then assigns them to the correct position |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign number to correct range
Hi,
Sorry, the numbers (250, 800 etc) aren't random. "JMay" wrote: There is a function RANDBETWEEN(Bottom#,Top#) which may be a part of the Tool-Pack_AddIn, But that is what you need. With A1:A4 = 0, 500, 750, 1000 In Cell B2 enter =RANDBETWEEN(A1, A2) -- Copy down to B4 HTH "blinton25" wrote in message : I have a range of numbers representing a culmalative total for a population e.g: 1 500 2 750 3 1000 I then generate a sequence of random numbers, e.g 250, 800 etc. So if I get 250 it should appear beside 1 (since it is less than 500), and if I get 800 it should appear beside 1000 ((since it is less than 1000). Anyway to do this? I have no problem with a solution that reads the random numbers generated and then assigns them to the correct position |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Assign Stock Number By Model | Excel Discussion (Misc queries) | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
A Challenge: Detection of first and Last +ve number in a range | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |