Hi,

i am using this formula:

=OFFSET(A:A,1,0,COUNTA(A:A)-1,1) to find last item in column.

Problem is that i have blank like here:
Null
Value
Value

and countA does not include empty here so my list is shorter.

Screenshot_29.png

do you know how to solve the issue?

Jacek