Greetings All,

I am trying to figure out a way to generate a random time series in Excel 2010 between two numbers that can vary. Yes, RANDBETWEEN is good for this, but I want a time series to be generated from a single cell start point (i.e., maybe RANDBETWEEN as a random seed generator), so that I don't have a huge amount of cells that just say "=RANDBETWEEN(min,max)", where all of the cells would be reliant on the static values of "min" and "max" in my worksheet. However, the RANDBETWEEN function can be used in the resultant time series column if they are governed by the starting seed value (not just the min/max values) -- I just can't think of how to get this done.

The reason that I want the randomization process to happen in this fashion is that I need to incorporate the Solver to manipulate the RANDBETWEEN value to ultimately produce some distribution parameters across the time series, but I am trying to work around the onboard Solver's 200 variable limit, and I may have to work with time series that are well in excess of 200 periods. If I can just have a time series generated by a single seed, it would be highly advantageous.

Many thanks in advance,

LBF