The last numeric value from C5:N5...

=LOOKUP(9.99999999999999E+307,C5:N5)

The next-to-last numeric value from C5:N5

=LOOKUP(9.99999999999999E+307,C5:INDEX(C5:N5,MATCH (9.99999999999999E+307,C5:N5)-1))

chewmanfoo wrote:
That formula works fine for columns A-L, but my formula needs to be
C5-N5, so I can't figure out how to transpose it. I think one of the
values in the formula specifies an offset, but which one.

I'm using this formula:

=OFFSET(O5,0,MATCH(9.99999999999999E+307,C5:N5)-COLUMN(O5))/OFFSET(O5,0,MATCH(9.99999999999999E+307,C5:N5)-COLUMN(O5)-1)-1

I spent a half an hour in Excel Help trying to figure this out, nogo.

Can you tell me how to transpose it?

TIA,
chewmanfoo