Split data with a equal total (approximately)

[rajeshn_in]

Hi friends,

I have some data with different numbers. I want to split that data in to 5 equal columns(approx.). Every time I have to do this manually, and its taking too much time.

Is there any possibility with the excel formulas to get result.

Please find attachment for better understanding.

Note : Values no need to come in same order which was in worksheet.