Selecting specific row/column from a named range
Suppose I have a named range "MyRange" (let's say it spans 10 rows and
10 cols) and I want to select only the 5th row in this range. Is there
a formula that will let me do that?
An extension to the question is what if I wanted only the 5th row and
the first three columns of this range?
Thanks!
Karthik
|