Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |