RandBetween Formula Help

[acbh]

Hi,

I need some help developing a formula that I believe should probably include RandBetween. I need 50 random numbers total to be placed in column J starting at row 6. I have a target number in cell J3 that all 50 random numbers generated must sum to. Each of the 50 numbers cannot be a larger number than that of the number found in the same row in column I (the numbers in column I change with each row). Example is below:

I J
3 6000
4
5
6 1505 rand
7 5625 rand
8 2568 rand
9 3256 rand

in this example all rand numbers in rows 6-9 will sum to 6000 (found in J3) but will not be larger then their corresponding numbers in column I. So, one combination could be 1123, 856, 2568, 1453.

Can anyone help with a formula NOT VBA method?

Many thanks,
Ann