Divide a list

Hi,

Can anyone please suggest how to apply formula in dividing the list into two equal parts and two unequal parts. I am attaching the list.

I will state the conditions.


Equal parts :

The ratio of R, S and SS should be same and avg should be same. The avg is calculated by dividing Vol by pieces.


Unequal parts :

The current ratio of r is 44, s is 46 and ss is 10. please suggest how can we divide the list into r - 30, s - 60 and ss - 10.


Please consider this as very very urgent for me.




Regards,List to be divided into equal and unequal parts.xls

Guys....Please help me or suggest the best place to put this request...