How to know the last row?
 

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

How to know the last row?
 

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

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

How to know the last row?
 

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" wrote:


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

How to know the last row?
 

great!

Thanks Mike.

have a nice day
--
Lorenzo DÃ*az
Cad Technician


"Mike H" wrote:

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" wrote:


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