Thanks for your formula. I tried with the formula, when I changed the group value to 1, the minimum amount should come to 150. and the total distribution across group value should sum up to 213000.
But now in the attached sheet, the group value for 1 (NAME I) is coming to 25.83, but it should be 150 and the balance (213000 - 150 = 212850) to be distributed in other rows.
The formula which you shared gives the same result when I use the below formula
The difficult part for me is to get 150 for minimum value 1 and the total points to be distributed across the row where the total should be equal to the Total Points
Bookmarks