Refer to only certain cells in a named range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mdalban@gmail.com - 25 Sep 2006 23:52 GMT

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?

Reply to this Message

Dave Peterson - 25 Sep 2006 23:56 GMT

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?

Signature

Dave Peterson

Reply to this Message