T
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
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