Thank You...you saved me hrs of work.
--
joec


"MyVeryOwnSelf" wrote:

Is there a formula I can use to return the most recent months value.

For exmple I have in col A all 12 months jan to dec. In col B
numerical data. I want to be able to bring the current months number
to a specific cell that will chg each time the next months data is
entered.

If the numbers are positive and there are no gaps, this might help:
=OFFSET(B1,COUNTIF(B1:B12,"0")-1,0)

Modify to suit.