How to eliminate zeros in a row

Hi there-

I created a formulation and it does the calculation and assign numbers to column A, B, C, D, E, F, G, H, I, J.


----A---B---C---D---E---F---G---H---I---J
R1--1---0---0---0---0---0---0---0---0---0
R2--0---3---0---0---0---0---0---0---0---0
R3--0---0---0---0---4---0---0---0---0---0
R4--0---0---0---0---0---0---0---1---0---0
R5--0---0---0---0---0---0---0---0---0---6

This is how table looks like. Every row only has 1 number and the rest is always 0. I am trying to create a formulation to capture the only value in the row. So I will have another Column which will be called FINAL COLUMN, This Column will display the only value in the row. So for R1, it will be 1 or for R5, it will be 6. I cannot use sum because the number has spaces in front of them and I really need these spaces for my database formulation. So is there any way to capture this number with it's spaces. So there will be no change for the value.

Perhaps a little shorter = SUM(A1:J1) and pull down as needed

or =max(A1:J1)

Originally Posted by popipipo

or =max(A1:J1)

Supposing all numbers are >0, yes

Look at #2:

i JUST SOLVED IT WITH A VERY BASIC FORMULATION SO THANKS. I ALSO POST THE ANSWER

=IF(C2>0,C2,IF(D2>0,D2,IF(E2>0,E2,IF(F2>0,F2,IF(G2>0,G2,IF(H2>0,H2,IF(I2,I2,IF(J2>0,J2))))))))