1) Col A - time stamps

Just in case the "time-stamps" in col A in Sheet1 may interfere,
you could try instead in B2 (in Sheet2)

=INDEX(Sheet1!B1:M1,MATCH(MAX(OFFSET(Sheet1!B1:M1, COUNTA(Sheet1!A:A)-1,)),OF
FSET(Sheet1!B1:M1,COUNTA(Sheet1!A:A)-1,),0))

(It's the same formula as the earlier one essentially,
but now with "Sheet1!B1:M1" replacing "Sheet1!1:1")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----