Domenic,
The formula for text gives the last non-empty data, not the previous.
Thank you
--
Cong Nguyen



"Domenic" wrote:

If the data contains numerical values...

=LOOKUP(9.99999999999999E+307,A2:INDEX(A2:A100,MAT CH(9.99999999999999E+30
7,A2:A100)-1))

If the data contains text values...

=LOOKUP(REPT("z",255),A2:INDEX(A2:A100,MATCH(REPT( "z",255),A2:A100)-1))

Adjust the ranges accordingly.

Hope this helps!

In article ,
Cong Nguyen wrote:

Is there a way to select the next to last non-empty cell in a row?
Thank you.