Ich in einer Tabelle in Spalte L die zahlen 0 o. 1 o. 2 o.3 stehen
Jetzt möchte ich eine Serie filtern.
Zb wie oft kommt die "0" oder die "1" hintereinander in Spalte L2:L6000 vor.
Wie könnte man das filtern ?
Gruß, Heinz
L | M | N | |
2 | 1 | 0 | 1 |
3 | 2 | 0 | |
4 | 4 | 0 | |
5 | 2 | 0 | |
6 | 1 | 0 | |
7 | 2 | 0 | |
8 | 4 | 0 | |
9 | 3 | 0 | |
10 | 2 | 0 | |
11 | 1 | 0 | |
12 | 1 | 1 | |
13 | 1 | 2 | |
14 | 1 | 3 | |
15 | 4 | 0 | |
16 | 3 | 0 | |
17 | 3 | 1 | |
18 | 4 | 0 | |
19 | 4 | 1 | |
20 | 3 | 0 | |
21 | 4 | 0 | |
22 | 2 | 0 | |
23 | 3 | 0 | |
24 | 4 | 0 | |
25 | 2 | 0 | |
26 | 4 | 0 | |
27 | 2 | 0 | |
28 | 4 | 0 | |
29 | 1 | 0 | |
30 | 4 | 0 |
P | Q | R | |
2 | 2 | 0 | 3 |
3 | 3 | 0 | |
4 | 3 | 1 | |
5 | 3 | 2 | |
6 | 3 | 3 | |
7 | 3 | 4 | |
8 | 3 | 5 | |
9 | 3 | 6 | |
10 | 1 | 0 | |
11 | 4 | 0 | |
12 | 1 | 0 | |
13 | 4 | 0 | |
14 | 3 | 0 | |
15 | 1 | 0 | |
16 | 4 | 0 | |
17 | 2 | 0 | |
18 | 4 | 0 | |
19 | 3 | 0 | |
20 | 1 | 0 | |
21 | 4 | 0 | |
22 | 3 | 0 | |
23 | 4 | 0 | |
24 | 3 | 0 | |
25 | 4 | 0 | |
26 | 4 | 1 | |
27 | 2 | 0 | |
28 | 4 | 0 | |
29 | 4 | 1 | |
30 | 1 | 0 |
M | N | |
1 | ||
2 | 0 | 1 |
Formeln der Tabelle | ||||||
|