Return last number in a Row Range

[Tonyd789]

Hi All

i have a basic table with months across the top and topics down the right side, each 1 of those topics scores a point each month. i'm after a formula that will return the last score for a topic in each row.

Can someone please help me.

Regards

 

[Aladin Akyurek]

1.

=LOOKUP(9.99999999999999E+307,B2:M2)

2.

=LOOKUP(9.99999999999999E+307,B2:INDEX(B2:M2,MATCH(9.99999999999999E+307,B2:M2)-1))

See: https://www.mrexcel.com/forum/excel-questions/102091-9-9999999-a.html for the big look up value.