Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allocating remainders
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allocating remainders
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allocating remainders
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allocating the numbers from the total | Excel Worksheet Functions | |||
Whole numbers and remainders | Excel Discussion (Misc queries) | |||
Allocating a value from a cell | Excel Worksheet Functions | |||
allocating between positive and negative amounts | Excel Worksheet Functions | |||
Allocating a Value | Excel Worksheet Functions |