Find last row with a numeric value in a range

[JCK101]

I'm trying to find the last row with a numeric value in a range (R8:X57).

I tried this: =MIN(ROW(R8:X57))+ROWS(R8:X57)-1

The result was 57 instead of 11 since the rows 12 to 57 have no values, but do have formulas.

I tried =LOOKUP(2,1/(LEN(R:X)>0),ROW(INDIRECT("1:65536"))) the result is 7 instead of 11, 7 is the heading row.

I tried this next one, it works, but it is too UGLY: =MAX(LOOKUP(2,1/(LEN(R:R)>0),ROW(INDIRECT("1:65536"))),LOOKUP(2,1/(LEN(S:S)>0),ROW(INDIRECT("1:65536"))), LOOKUP(2,1/(LEN(T:T)>0),ROW(INDIRECT("1:65536"))),LOOKUP(2,1/(LEN(U:U)>0),ROW(INDIRECT("1:65536"))),LOOKUP(2,1/(LEN(V:V)>0),ROW(INDIRECT("1:65536"))),LOOKUP(2,1/(LEN(W:W)>0),ROW(INDIRECT("1:65536"))),LOOKUP(2,1/(LEN(X:X)>0),ROW(INDIRECT("1:65536"))))

Any help will be appreciated.

Regards,
JC

 

[Peter_SSs]

Thank you again.

You are welcome again.