How to know the last row?

  • Thread starter Thread starter ldiaz
  • Start date Start date
L

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
 
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
 
Back
Top