Increasing Month only in formula
 

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

Increasing Month only in formula
 

On Thu, 11 Feb 2010 12:53:01 -0800, Malla
wrote:

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

If I understand you correctly, try:

A1: =INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,COLUMNS($A:A), 1),"mmm")))

and drag right to L1

--ron

Increasing Month only in formula
 

Yes and no. You will have to add a helper column with Jan, Feb, Mar, ... in
the cells.
Assuming that is in Cell B2, B3, ... then in A2 use the formula

=indirect(b2 & "!G2")
And drag down. Note that this formulas has a surprising amount of overhead
to it so if you have thousands of these you will notice taht you spread sheet
calculates slowly.
--
HTH...

Jim Thomlinson


"Malla" wrote:

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

Increasing Month only in formula
 

On Thu, 11 Feb 2010 16:03:52 -0500, Ron Rosenfeld
wrote:

On Thu, 11 Feb 2010 12:53:01 -0800, Malla
wrote:

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

If I understand you correctly, try:

A1: =INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,COLUMNS($A:A), 1),"mmm")))

and drag right to L1

--ron

Sorry, I first thought you were filling columns.

Make this change:

=INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,rowS($1:1),1), "mmm")))

then fill down to A12.
--ron

Increasing Month only in formula
 

Try this...

=INDIRECT(TEXT(ROWS(A$1:A1)*29,"mmm")&"!G2")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Malla" wrote in message
...
Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have
"=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?