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.

ramtroop wrote:
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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ramtroop" wrote in message
...
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.