Hi all,,
iam new member here and i really would ur assistance with a problem that i faced at my work, i searched a lot and couldn't find anything that may help me, here's my problem :
help.jpg
"u can see the attachment"
As you see I need some kind of formula that automatically redistribute numbers in the blue columns without changing the value of the number (only changing positions) so the totals of all columns will be (<= 10 ) or near , and if i increased on of the number's and there's no way to distribute equally for each group to be 10, it should tell me you have to add another group ,, i tried to use solver and it didn't help me a lot and i will attache the workbook that i have working on.
thanks all
best regards
Bookmarks