Zelle | Formel |
A8 | =C1 |
B8 | =MIN(C8:K8) |
C8 | =WENN(C1=D1;" ";SPALTE()-2) |
D8 | =WENN(C8<>" ";"";WENN(D1=E1;" ";SPALTE()-2)) |
E8 | =WENN(D8<>" ";"";WENN(E1=F1;" ";SPALTE()-2)) |
F8 | =WENN(E8<>" ";"";WENN(F1=G1;" ";SPALTE()-2)) |
G8 | =WENN(F8<>" ";"";WENN(G1=H1;" ";SPALTE()-2)) |
H8 | =WENN(G8<>" ";"";WENN(H1=I1;" ";SPALTE()-2)) |
I8 | =WENN(H8<>" ";"";WENN(I1=J1;" ";SPALTE()-2)) |
J8 | =WENN(I8<>" ";"";WENN(J1=K1;" ";SPALTE()-2)) |
K8 | =WENN(J8<>" ";"";WENN(K1=L1;" ";SPALTE()-2)) |
A9 | =C2 |
B9 | =MIN(C9:K9) |
C9 | =WENN(C2=D2;" ";SPALTE()-2) |
D9 | =WENN(C9<>" ";"";WENN(D2=E2;" ";SPALTE()-2)) |
E9 | =WENN(D9<>" ";"";WENN(E2=F2;" ";SPALTE()-2)) |
F9 | =WENN(E9<>" ";"";WENN(F2=G2;" ";SPALTE()-2)) |
G9 | =WENN(F9<>" ";"";WENN(G2=H2;" ";SPALTE()-2)) |
H9 | =WENN(G9<>" ";"";WENN(H2=I2;" ";SPALTE()-2)) |
I9 | =WENN(H9<>" ";"";WENN(I2=J2;" ";SPALTE()-2)) |
J9 | =WENN(I9<>" ";"";WENN(J2=K2;" ";SPALTE()-2)) |
K9 | =WENN(J9<>" ";"";WENN(K2=L2;" ";SPALTE()-2)) |
A10 | =C3 |
B10 | =MIN(C10:K10) |
C10 | =WENN(C3=D3;" ";SPALTE()-2) |
D10 | =WENN(C10<>" ";"";WENN(D3=E3;" ";SPALTE()-2)) |
E10 | =WENN(D10<>" ";"";WENN(E3=F3;" ";SPALTE()-2)) |
F10 | =WENN(E10<>" ";"";WENN(F3=G3;" ";SPALTE()-2)) |
G10 | =WENN(F10<>" ";"";WENN(G3=H3;" ";SPALTE()-2)) |
H10 | =WENN(G10<>" ";"";WENN(H3=I3;" ";SPALTE()-2)) |
I10 | =WENN(H10<>" ";"";WENN(I3=J3;" ";SPALTE()-2)) |
J10 | =WENN(I10<>" ";"";WENN(J3=K3;" ";SPALTE()-2)) |
K10 | =WENN(J10<>" ";"";WENN(K3=L3;" ";SPALTE()-2)) |
A11 | =C4 |
B11 | =MIN(C11:K11) |
C11 | =WENN(C4=D4;" ";SPALTE()-2) |
D11 | =WENN(C11<>" ";"";WENN(D4=E4;" ";SPALTE()-2)) |
E11 | =WENN(D11<>" ";"";WENN(E4=F4;" ";SPALTE()-2)) |
F11 | =WENN(E11<>" ";"";WENN(F4=G4;" ";SPALTE()-2)) |
G11 | =WENN(F11<>" ";"";WENN(G4=H4;" ";SPALTE()-2)) |
H11 | =WENN(G11<>" ";"";WENN(H4=I4;" ";SPALTE()-2)) |
I11 | =WENN(H11<>" ";"";WENN(I4=J4;" ";SPALTE()-2)) |
J11 | =WENN(I11<>" ";"";WENN(J4=K4;" ";SPALTE()-2)) |
K11 | =WENN(J11<>" ";"";WENN(K4=L4;" ";SPALTE()-2)) |
D12 | =WENN(C12<>"";"";WENN(D5=E5;"";SPALTE()-2)) |
E12 | =WENN(D12<>"";"";WENN(E5=F5;"";SPALTE()-2)) |
F12 | =WENN(E12<>"";"";WENN(F5=G5;"";SPALTE()-2)) |
G12 | =WENN(F12<>"";"";WENN(G5=H5;"";SPALTE()-2)) |
H12 | =WENN(G12<>"";"";WENN(H5=I5;"";SPALTE()-2)) |
I12 | =WENN(H12<>"";"";WENN(I5=J5;"";SPALTE()-2)) |
J12 | =WENN(I12<>"";"";WENN(J5=K5;"";SPALTE()-2)) |
K12 | =WENN(J12<>"";"";WENN(K5=L5;"";SPALTE()-2)) |