Dear Excel Experts,

I have problem:

I have a column (say, A) having 1000 values; ranging from anything 2 to 35 in each of the cell of that column.

suppose, cell A1 has value of 20. I need to divide this value of 20 in some 'random' number of parts.. e.g., mentioning randbetween (1,5)..so that sum of all the parts should equal to 20 only.. and each part should be integer. again, i have no fixed percentage that each part would be having.

Also, each part must be put into a separate column .i.e., if 20 has been broken into 4 parts of 6,9,4,1 .. then these numbers will be put in different column say.. D1,D2,D3,D4...

once i do it for single cel... then I need to run this for all 1000 cells mentioned in column 'A'... with each split entry getting appended after the last division of entries.... eg.. '20' was divided into D1,D2,D3,D4.....so, next cell value, once divided, will continue from D5, D6, D7.. etc..


Please help urgently