Dave Peterson wrote:

Maybe you can use a range that grows and contracts depending on the
entries:
http://contextures.com/xlNames01.html#Dynamic
(from Debra Dalgleish's site)

That's cute, I hadn't seen that before.

I got what I want by using MATCH in the OFFSET formula to find the first and
last occurrences of a start date and end date, then I used the dynamic range
in the array formula.

Superb, thanks a bunch!


Wilba wrote:

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!