| Zelle | Formel |
| F5 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1)); SPALTE(B$1)-1))} |
| G5 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1)); SPALTE(C$1)-1))} |
| H5 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1)); SPALTE(D$1)-1))} |
| I5 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A1)); SPALTE(E$1)-1))} |
| F6 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2)); SPALTE(B$1)-1))} |
| G6 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2)); SPALTE(C$1)-1))} |
| H6 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2)); SPALTE(D$1)-1))} |
| I6 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A2)); SPALTE(E$1)-1))} |
| F7 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3)); SPALTE(B$1)-1))} |
| G7 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3)); SPALTE(C$1)-1))} |
| H7 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3)); SPALTE(D$1)-1))} |
| I7 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A3)); SPALTE(E$1)-1))} |
| F8 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4)); SPALTE(B$1)-1))} |
| G8 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4)); SPALTE(C$1)-1))} |
| H8 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4)); SPALTE(D$1)-1))} |
| I8 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A4)); SPALTE(E$1)-1))} |
| F9 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5)); SPALTE(B$1)-1))} |
| G9 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5)); SPALTE(C$1)-1))} |
| H9 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5)); SPALTE(D$1)-1))} |
| I9 | {=WENN(ISTFEHLER(KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5))); "";INDEX($A:$D;KKLEINSTE(WENN($A$5:$A$100=$F$3;ZEILE($A$5:$A$100)); ZEILE($A5)); SPALTE(E$1)-1))} |