Hi, I would like a cell to return the last value in a column greater then 0.

So if the column has this in it:

100
250
500
300
0
0
0

I want the cell below that to display 300, then if i have

100
250
500
300
200
0
0

I want it to change to 200

Make sense?

thanks for your help.
Paul