| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
