Displaying furthest right value in row

Originally Posted by Pepe Le Mokko

Hi
Depending obthe type of content have alook at http://www.xldynamic.com/source/xld.LastValue.html

Thank you! The link was great!
For future reference, the formula which works in this case is:
=INDEX(42:42,MATCH(9.99999999999E+307,42:42))