Hi
I have this problem
A1
Ar Th Math res chem mater draw e1 inf top hy ws draws
45 70 80 55 60 70 80 46 70 80 57 70 80 45 55 46 57
46 57 4 3 3
I have data from a1 to m1
in n2 min of a2 to c2
in o2 min of d2 to g2
in p2 min of h2 to j2
in q2 min of k2 to m2
in r2 this formula IF(N2P2;N2;P2)
in s2 this formula IF(O2Q2;O2;Q2)
in t2 this formula 50-R2
in u2 this formula 60-S2
in v2 this formula IF(T2U2;U2;T2)
in w2 tis formula IF(V2=3;LOOKUP(S2;A2:M2;C1:M1)) which give math which
is not correct, is this because lookup wants the data in ascending
order, I can not put in this order any help
Thank you all in advance
Regards
Jam