You could use Dynamic Named Ranges though I'd advise using INDEX construct rather than OFFSET given use with Array
Alternatively, using your example:
as you can see a certain amount of repetition re: MATCH using this approach
you might consider storing the row number of the last number in each relevant column in row 1 of the same column such that you can avoid the multitude of MATCHes taking place and refer simply to row 1
pending set up it might be the case that you could replace ROWS with a basic COUNT (of entire column)
Bookmarks