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)

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!

--

Dave Peterson