Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Reference Cell in Offset Formula
Can I have a dynamic reference cell in my offset formula? What I would like
to do is have my offset formula select the last 24 months from my list of months in col. A. So when the next month is added my range will change. For example, in Jan. 07, I would like my offset formula to return the months for Jan05-Jan07. Then for Feb. 07 I would like it to return Feb05-Feb07, for march return March 05-march 07 and so on. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
CELL Function: cell reference by formula | Excel Worksheet Functions | |||
Cell reference in different worksheet in formula | Excel Worksheet Functions |