Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i just want to allocate $ by month, for many projects | Excel Worksheet Functions | |||
How to allocate based on seniority | Excel Discussion (Misc queries) | |||
allocate different colors to each number | Excel Worksheet Functions | |||
How to allocate the XLODBC.XLA software? | Excel Discussion (Misc queries) | |||
Allocate a value to a cell from an if statement | Excel Worksheet Functions |