how to find a last value in a column in numbers even when there are empty columns in
In Numbers file, need to find a last value in the column even when there are empty columns in between
Question marked as
It's non-obvious, but to find the last value in column B you can use the formula:
=LOOKUP(REGEX(".*"),B)
(substitute the 'B' for any other column or range to search)
REGEX() uses regular expressions to find values, in this case ".*" represents 'any value', i.e. non-blank cells.
This is passed as a parameter to lookup which creates a reference to a cell and returns the last cell in the range.