excel spreadsheet

[joec]

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.

 

[FSt1]

hi
not sure if i understand you but try this
=month(now())

regards
FSt1

 

[MyVeryOwnSelf]

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.

 

[joec]

I don't think I was clear:

For example: Jan 50
Feb 49
Mar
Apr

XX (is there a formula that will
return 49 as a value in cell xx? And then return a new value if data added to
cell next to march?)
joec

 

[joec]

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

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

Modify to suit.

 

[T. Valko]

Try one of these:

=LOOKUP(1E100,B1:B12)

=INDEX(B1:B12,MONTH(NOW()))

 

[Roger Govier]

Hi

Assuming your values will be in cells b1:B12
=LOOKUP(99^99,B1:B12)
will give you the last value entered in that range.