Dynamic Cell Range

[theillknight]

I want to use the index() function, but the size of my data continuousl
changes. I'm pretty sure I'll have to use some variation of th
indirect() function, but I'm not sure how to piece it all together.

Say I have data in A1:B3. Then, I insert more data so the rang
becomes A1:C5. How can I make it so that the array I reference expand
or shrinks to encompass all occupied cells

 

[Frank Kabel]

Hi
onw way:
=OFFSET($A$1,0,0,COUNTA($A:$A)-1)

for adjusting the row size

 

[theillknight]

Thanks. The only problem I have with this formula is that if the cell
in the range aren't populated, then the formula won't encapsulate th
entire range. Is there an alternate method? Something using match(
perhaps