View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.