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