Simply using a spreadsheet to manage my finances, and I’d like to be able to use my latest balance in formulae. It’s always going to be the lowest (position within the sheet) populated cell, in a certain column.
So far, I’ve got as far as
=CELL(“SHEET”, CELL(“ADDRESS”, CONCATENATE(“E”, 3+MATCH(".+",SheetName.E3:E99999, -1))))
With “SheetName” being whatever the sheet is called, and “E” being the column. It simply returns “#REF!”.
The 3 being added to the match is to account for the headers (column names, etc.)