Function

[excelblack]

Hi,

I'd like to know if there is a function that can give me the last valid
result in a list. It can be in VBA.

Thank's

 

[Peo Sjoblom]

If there are no blank rows involved you can use something like

=OFFSET(A1,COUNTA(A:A)-1,)

if blanks can be involved

=INDEX(A:A,MAX((A1:A1000<>"")*ROW(INDIRECT("1:1000"))))

entered with ctrl + shift & enter (change the size if you expect more than
1000 rows)

 

[Jason Morin]

"Valid" can mean many things. Try:

=INDEX(A1:A20,MAX(IF(LEN(A1:A20)>0,ROW(A1:A20))))

Array-entered, meaning press ctrl/shift/enter. Change the
range to meet your needs.

HTH
Jason
Atlanta, GA