What errors?

If your data is continuous you can use

=INDEX(A:A,COUNTA(A:A))


In article ,
pateodoro wrote:

Unfortunalely your answer did not help me... :-(

That formula resulted in lots of erros which I could not repair...