Based on the other two responses you got, it looks like I came up with the
*hard* way to do this.<g

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Here is one way...

=INDEX(A1:A1000,SUMPRODUCT(MAX((A1:A1000<0)*ROW(A 1:A1000))))

Change the A1000 reference to a row reference higher than the maximum row
you ever expect to make use of in Column A.

Rick


"Anto111" wrote in message
...
Hi Guys,

I need to find the last value within a column range that is greater than
zero.

For example, Within A1:A8 I have values of 1,0,3,5,6,0,0,0 I therefore
need
excel to recognise the number 6 and ignore the subsequent 3 zero's.

I also need this to update with new data, so for example If A9 is zero
then
continue to recognise the last value as 6, but if A9 is 2 then recognise
the
most recent value as 2.

Sorry if the example is not clear.

Kind regards,

Ant