Formula using indirect

sturnusek

New Member
Joined
Sep 20, 2018
Messages
49
Hi all,

I need a little bit of a help to make a formula...

I might have two lines with the same component in a big list, and I want my stock figure to be updated in the second line based on previous calculation.

I tried to use indirect and ROW()-1, but had no luck.

So, I have a available stock figure made against a component in J2:J column, and the demand column in I2:I column.

There can be two lines using the same component, and I am in need of a formula that will minus the stock from the fist line I-J, and then the available stock figure to reflect the first transaction on the second line and so on, allowing it to run into minus values.

So I need the second line to have the first lines demand to be taken off the available stock - I can imagine this cannot be done without creating additional column.

Any ideas?
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Your explanation is a bit confusing ...

May be you should try =Offset(yourcell,-1,0) ...

Hope this will help
 

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,486
Yes, this can be done with the INDIRECT function. For example,

=INDIRECT("R[-1]C",0)

will return the value of the cell immediately above the formula cell.
 
Last edited:

Forum statistics

Threads
1,086,241
Messages
5,388,649
Members
402,129
Latest member
saltoftheearth

Some videos you may like

This Week's Hot Topics

Top