Find the last entry in a column


Lookup Last Entry in a Column

You can retrieve the last entry in a column - what about blank cells ??
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.

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