| | A | B | C | D | E | F | G | H | | 1 | | | | | Spalte | | | | | 2 | | | | | Ausblenden! | | | | | 3 | Gebiet Nr. | PLZ | Umsatz | Umsatz % | | | | | | 4 | 100 | | 200,00 | 9,13% | 0,091320201 | | | | | 5 | 101 | | 988,00 | 45,11% | 0,451136553 | | | | | 6 | 102 | | | | -0,000006 | | | dazugehörige
Gebiets Nr. |
|---|
| 7 | 103 | | | | -0,000007 | | | | 8 | 104 | | | | -0,000008 | Beste | 45,11% | 101 | | 9 | 105 | | 125,00 | 5,71% | 0,057068626 | 2.beste | 11,83% | 123 | | 10 | 106 | | | | -0,00001 | 3.beste | 11,42% | 108 | | 11 | 107 | | | | -0,000011 | 4.beste | 9,13% | 100 | | 12 | 108 | | 250,00 | 11,42% | 0,114143251 | 5.beste | 5,71% | 105 | | 13 | 109 | | | | -0,000013 | | | | | 14 | 110 | | 100,00 | 4,57% | 0,0456481 | | | | | 15 | 111 | | | | -0,000015 | | | | | 16 | 112 | | | | -0,000016 | | | | | 17 | 113 | | | | -0,000017 | | | | | 18 | 114 | | | | -0,000018 | | | | | 19 | 115 | | | | -0,000019 | | | | | 20 | 116 | | | | -0,00002 | | | | | 21 | 117 | | | | -0,000021 | | | | | 22 | 118 | | | | -0,000022 | | | | | 23 | 119 | | | | -0,000023 | | | | | 24 | 120 | | | | -0,000024 | | | | | 25 | 121 | | | | -0,000025 | | | | | 26 | 122 | | | | -0,000026 | | | | | 27 | 123 | | 259,00 | 11,83% | 0,11823784 | | | | | 28 | 124 | | | | -0,000028 | | | | | Formeln der Tabelle | E4 : =D4-ZEILE()/1000000
E5 : =D5-ZEILE()/1000000
E6 : =D6-ZEILE()/1000000
E7 : =D7-ZEILE()/1000000
E8 : =D8-ZEILE()/1000000
G8 : =INDEX($D$4:$D$28;VERGLEICH(KGRÖSSTE(D$4:D$28;ZEILE(A1));D$4:D$28;0))
H8 : =INDEX($A$4:$A$28;VERGLEICH(KGRÖSSTE(E$4:E$28;ZEILE(A1));E$4:E$28;0))
E9 : =D9-ZEILE()/1000000
G9 : =INDEX($D$4:$D$28;VERGLEICH(KGRÖSSTE(D$4:D$28;ZEILE(A2));D$4:D$28;0))
H9 : =INDEX($A$4:$A$28;VERGLEICH(KGRÖSSTE(E$4:E$28;ZEILE(A2));E$4:E$28;0))
E10 : =D10-ZEILE()/1000000
G10 : =INDEX($D$4:$D$28;VERGLEICH(KGRÖSSTE(D$4:D$28;ZEILE(A3));D$4:D$28;0))
H10 : =INDEX($A$4:$A$28;VERGLEICH(KGRÖSSTE(E$4:E$28;ZEILE(A3));E$4:E$28;0))
E11 : =D11-ZEILE()/1000000
G11 : =INDEX($D$4:$D$28;VERGLEICH(KGRÖSSTE(D$4:D$28;ZEILE(A4));D$4:D$28;0))
H11 : =INDEX($A$4:$A$28;VERGLEICH(KGRÖSSTE(E$4:E$28;ZEILE(A4));E$4:E$28;0))
E12 : =D12-ZEILE()/1000000
G12 : =INDEX($D$4:$D$28;VERGLEICH(KGRÖSSTE(D$4:D$28;ZEILE(A5));D$4:D$28;0))
H12 : =INDEX($A$4:$A$28;VERGLEICH(KGRÖSSTE(E$4:E$28;ZEILE(A5));E$4:E$28;0))
E13 : =D13-ZEILE()/1000000
E14 : =D14-ZEILE()/1000000
E15 : =D15-ZEILE()/1000000
E16 : =D16-ZEILE()/1000000
E17 : =D17-ZEILE()/1000000
E18 : =D18-ZEILE()/1000000
E19 : =D19-ZEILE()/1000000
E20 : =D20-ZEILE()/1000000
E21 : =D21-ZEILE()/1000000
E22 : =D22-ZEILE()/1000000
E23 : =D23-ZEILE()/1000000
E24 : =D24-ZEILE()/1000000
E25 : =D25-ZEILE()/1000000
E26 : =D26-ZEILE()/1000000
E27 : =D27-ZEILE()/1000000
E28 : =D28-ZEILE()/1000000
|
|