Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In a LABEL Range(say that it has 12 elements row-wise), how do one refer
to the 4th elements? I have this ideas that in a worksheet, I have 12 rows single column LABELED range called MONTHS, where 1st elements is JAN(that is C6), and so on, and last element would be DEC(C17). How do I get the 4th element which will be APR, and put that value in the different cell using the LABEL reference instead of the absolute cell location(C9)? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
HTML_Control Range name | Excel Discussion (Misc queries) | |||
Vlookup Question | Excel Discussion (Misc queries) |