I have a range of balances that I'm trying to segregate into groups that are 10% of the total of all balances. So say all balances between 0-50, would be 10% of the total of all balances, and 50-75 would be 10% of the total of all balances,.....and so on. So I want 10 ranges, where the sum of all the balances in a range is 10% of the total of all balances.
I can do this by sorting and creating a cumulative percentage formula and finding the points where the cumulative percentage equals 10%, 20% and so on, but I need a formula that can calculate this without the sorting.
I can do this by sorting and creating a cumulative percentage formula and finding the points where the cumulative percentage equals 10%, 20% and so on, but I need a formula that can calculate this without the sorting.
