Hi Ron,

Sorry this does work was entering wrong formula, Thanx a great deal, much
appreciated.

Regards


Mark

"Ron Coderre" wrote:

With
your posted data structure beginning in cell A1
Col_A contains Date
Col_B contains Stock In/Out
Col_C contains Balance
Col_D contains Stock Remaining

This returns the last status of Col_D corresponding to the last Stock In/Out
entry:
E1: =INDEX(D:D,MATCH(10^99,B:B))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"santaviga" wrote:

Date Stock In/Out Balance Stock Remaining
20 120 Stock OK
20 140 Stock OK
30 170 Stock OK
-50 120 Stock OK
-60 60 Stock OK

I have the above set out in a worksheet, What I need is a formula to put in
a cell for the following: I need a cell e.g A10 to recognise the last entry
in column stock remaining. e.g the cell would return Stock OK or Order stock,
It need to be the last entry in the column and it must update when later
entries are entered into the Stock Remaining.

Can anyone help ????

Regards.


Santaviga