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.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top