| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
