Selecting specific row/column from a named range

  • Thread starter Thread starter kakofoniks
  • Start date Start date
K

kakofoniks

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
 
Hi!

Define "select".

=INDEX(MyRange,5,COLUMNS($A:A))

Copied across to 3 cells will return data from the first 3 columns of the
5th row from MyRange.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting rows. 3
Conditional formatting on a dynamic range - workaround 1
Picking out column in named range 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Delete rows based on contents of Col A 0
Dependent drop down dynamic range formula, off sheet. 7
Import multiple workbooks to current workbook in specified row number 0
Converting Rows into Columns 3

Back
Top