| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO EXTEND A NAMED RANGE | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
