Refer to only certain cells in a named range

M

mdalban

Is it possible to refer to only certain cells in a named range. ie. I
want to use in a formula the 2nd cell in a named column range, how do I
reference it in the formula?
 
D

Dave Peterson

One way:

=INDEX(myList,2)



Is it possible to refer to only certain cells in a named range. ie. I
want to use in a formula the 2nd cell in a named column range, how do I
reference it in the formula?
Click to expand...
 
Top