"Last numeric" function?

[Bob]

I'd like to find the last value in a row, sort of similar to MAX(B23:N23),
except that LAST(B23:N23) should return the right-most non-blank value. I
haven't found such a function... is there one?

Bob

 

[Frank Kabel]

Hi Bob
try
=INDEX(B23:N23,1,MAX(IF(ISNUMBER(B23:N23),ROW(B23:N23),0))-1)

HTH
Frank

 

[Gord Dibben]

Bob

=LOOKUP(9.99999999999999E+307,B23:N23)

=LOOKUP(9.99999999999999E+307,1:1) will find last numeric value in row 1.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
I forgot to mention that you have to enter the formula as array formula
(CTRL+SHIFT+ENTER)

Frank