Find the last entry in a column

blank

Lookup Last Entry in a Column

You can retrieve the last entry in a column - what about blank cells ??
{=INDIRECT(ADDRESS(MAX((A1:A4000<>"")*ROW(A1:A4000)),COLUMN(A1:A4000),4))}
This formula will not work if you try and use the whole column reference A:A for the range.
Also try and only reference the range that will potentially contain data, in this example we have used the range A1:A4000
Try and limit the last row to whatever is sensible but is as small as possible. This will prevent the formula taking an unnecessary amount of time to calculate.



© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top