Try in C3 (copy down)
I hope it helped.Code:=INDEX(F3:K3,MATCH(1E+99,F3:INDEX(F3:K3,MATCH(1E+99,F3:K3)-1)))
Thank you bosco. This really helpOr….................
In C3, copied down :
=LOOKUP(9^9,F3:INDEX(3:3,MATCH(9^9,3:3)-1))
Regards
Bosco