Hello
With VBA you can easily specify the last cell in a spreadsheet but how can you do that with formulas?
I am trying to specify a lookup range. The start of that range will be a specific column or row or cell. How can I specify all the columns, rows, cells to the right/down from that initial column, row or cell?
E.g. range start:
INDEX(A:A,MATCH(A1,A:A,0))
which resolves to G4
Range end:
All the cells to the right/down of G4.
Thanks!
With VBA you can easily specify the last cell in a spreadsheet but how can you do that with formulas?
I am trying to specify a lookup range. The start of that range will be a specific column or row or cell. How can I specify all the columns, rows, cells to the right/down from that initial column, row or cell?
E.g. range start:
INDEX(A:A,MATCH(A1,A:A,0))
which resolves to G4
Range end:
All the cells to the right/down of G4.
Thanks!