View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Allocate from the sum

G3: =G2-B3

and copy down.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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