View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
srpavar srpavar is offline
external usenet poster
 
Posts: 11
Default Allocate from the sum

I have work sheet like mentioned below, i am trying to increase or decrease
in load column, in the rest of the column it has to allocate the figures and
match with the load column. I am trying to write a formula, can anyone please
help me in this.

GBR RSL WDJ MAN ALK BRK LOAD
250 50 0 110 0 380 790
240 50 0 90 0 360 740
240 40 0 80 0 340 700
240 40 0 80 0 340 700
230 40 0 70 0 330 670
240 40 0 80 0 350 710