| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function like INDIRECT to return a range?
Hello. I'm using an array formula that will only accept a finite range as a
parameter (e.g. A2:A999). The array formula will not accept a named range or column reference (e.g. A:A). I'd like to specify the range dynamically rather than hardcode it, for instance by using MATCH to find the first and last rows with relevant data. Something like INDIRECT would be perfect, but INDIRECT can only return a cell reference, not a range (right?). Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| can I use Indirect function within range definitons for names? | Excel Worksheet Functions | |||
| I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
| Can INDIRECT return a range array? | Excel Worksheet Functions | |||
| How to paste INDIRECT function to range of cells? | Excel Worksheet Functions | |||
Threaded Mode
