How to know the last row?

[ldiaz]

I want to know the last row that cotain a value,
example: A5
1 A B
2 A-x
3 A-Y
4 A-Y
5 a-f


Other example: A4
1 A B
2 A-x
3 A-Y
4 A-Y

Thanks
LD

 

[Mike H]

Try

=ADDRESS(MATCH(REPT("z",255),A:A),1)

Mike

 

[ldiaz]

I want A5 instead of:$A$5


is it possible?
Thanks

 

[Mike H]

Try this

=ADDRESS(MATCH(REPT("z",255),A:A),1,4)

Try the numbers 1,2,3 or 4 as the last argument for different types

Mike

 

[ldiaz]

great!

Thanks Mike.

have a nice day