| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increasing payment in future value formula? | Excel Worksheet Functions | |||
| How do I copy a formula with the cell increasing by increments? | Excel Discussion (Misc queries) | |||
| increasing the row_index_num when you drag a formula | Excel Discussion (Misc queries) | |||
| Copy a formula to the right increasing the rows from another works | Excel Worksheet Functions | |||
| Copying data and increasing formula | Excel Worksheet Functions | |||
Linear Mode
