How to know the last row?
I want A5 instead of:$A$5
is it possible?
Thanks
--
Lorenzo DÃ*az
Cad Technician
"Mike H" wrote:
Try
=ADDRESS(MATCH(REPT("z",255),A:A),1)
Mike
"ldiaz" wrote:
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
--
Lorenzo DÃ*az
Cad Technician
|