jb
Member
Hello Helpers,
I have an excel sheet jb rank.xlsx. This excel sheet is a solution given by one member in this forum long back.
My problem was to add a value say 16 to range of cells in such a way that new value of cell after adding portion of value 16 to that cell should not exceed to any cell which has original value greater. and the distribution is to be done in such a way that all cells must get balanced values.
For example: 11, 6 , 9 , 15 , 8 ,17 will be balanced like 13, 12, 13, 15, 12, 17
Given solution gives correct output for some set of data. But when I enter following data 26 23 25 26 28 27 in B2 to G2 then it adjusts the cells with values 15 instead of 16.
Please help.
I have an excel sheet jb rank.xlsx. This excel sheet is a solution given by one member in this forum long back.
My problem was to add a value say 16 to range of cells in such a way that new value of cell after adding portion of value 16 to that cell should not exceed to any cell which has original value greater. and the distribution is to be done in such a way that all cells must get balanced values.
For example: 11, 6 , 9 , 15 , 8 ,17 will be balanced like 13, 12, 13, 15, 12, 17
Given solution gives correct output for some set of data. But when I enter following data 26 23 25 26 28 27 in B2 to G2 then it adjusts the cells with values 15 instead of 16.
Please help.
Attachments

11.9 KB Views: 8