Not real clear what you want.

Maybe this...

Return the last (right-most) non zero entry.

Data Range
A
B
C
D
E
F
G
H
I
J
1
88
11
58
86
0
67
62
0
0
0
2
------
------
------
------
------
------
------
------
------
------
3
62


This formula entered in A3:

=LOOKUP(2,1/(A1:J1<>0),A1:J1)