View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
blinton25 blinton25 is offline
external usenet poster
 
Posts: 2
Default 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