"Last numeric" function?

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
Hi Bob
try
=INDEX(B23:N23,1,MAX(IF(ISNUMBER(B23:N23),ROW(B23:N23),0))-1)

HTH
Frank
 
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
 
Hi
I forgot to mention that you have to enter the formula as array formula
(CTRL+SHIFT+ENTER)

Frank
 
Back
Top