Hi Everybody,

I have problem in generating random numbers depending on the other
cell value. My Problem is like this.
In column A I have 10 numbers Now I wnat to generate 20 random numbers,
This can be done By giving reference to one cell for two times.

Ex:

A1=1,A2=1,A3=2,A4=5,A5=2,A6=1,A7=2,A8=2,A9=1,A10=2
Now In B1=If(A1<=1,randbetween(10,20),randbetween(20,30))
In B2=if(A1=,randbetween(10,20),randbetween(20,30))
I used For B1&B2 the cell A1 as reference as because I have to generate
20 random numbers from 10 refernce cells in Column A. and this can be
done.(20/10=2)

But When we have only Say 7 reference cells in column A and the random
numbers to be generated are 20 in Column B what kind of relation ship
can I apply In column B.(20/7=2.85). Is there any method that the
references can be given for the column B in Column A to generate the
required random numbers.

Thanks and Regards

Ramana