A | B | C | D | E | F | G | H | I | |
1 | Spalte1 | Spalte2 | Spalte3 | Spalte4 | Spalte5 | Spalte6 | Spalte7 | ||
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | ||
7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | Erster Wert Spalte B | |
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 6 | |
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | ||
10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | ||
11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | ||
12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | ||
13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | ||
14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
verwendete Formeln | |||
Zelle | Formel | Bereich | N/A |
I8 | {=INDEX(B:B;MIN(WENN(TEILERGEBNIS(3;INDIREKT("B"&ZEILE(2:99)));ZEILE(2:99))))} | $I$8 | |
A6:G14 | =ZEILE() |