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 | |||
range names | Excel Worksheet Functions | |||
Question on LABEL Range | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |