Allocating remainders

[ramtroop]

Example--I have ten vendors, each gets a % of a total. The remainder needs
to be allocated to the vendor with the highest %. Any way to automate that.

 

[Glenn]

Example--I have ten vendors, each gets a % of a total. The remainder needs
to be allocated to the vendor with the highest %. Any way to automate that.

If you actually provide an example of the data and the result you are looking
for, I'm sure someone can get you a solution.

 

[Bernard Liengme]

Vendors in A1:A10 (say)
Allocated percentage in column D, say
In E1 use =D1+(D1=MAX($E$1:$E$10))*(100%-SUM($D$1:$D$10)
Copy down the column
The larges value in D causes the E value to have added to the D value, the
remainder of the percentage allocation
Problem if there are two equal maximum values
best wishes