excel spreadsheet
 

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.
--
joec

excel spreadsheet
 

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

regards
FSt1

"joec" 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.
--
joec

excel spreadsheet
 

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.

excel spreadsheet
 

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


"FSt1" wrote:

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

regards
FSt1

"joec" 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.
--
joec

excel spreadsheet
 

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.

excel spreadsheet
 

Try one of these:

=LOOKUP(1E100,B1:B12)

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



--
Biff
Microsoft Excel MVP


"joec" wrote in message
...
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.
--
joec

excel spreadsheet
 

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.

--

Regards
Roger Govier

"joec" wrote in message
...
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


"FSt1" wrote:

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

regards
FSt1

"joec" 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.
--
joec