{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Sortieren_1","Sort_Nach","Sortieren_2","Strukt_Verw","Sort_Nach2_1","Sort_Nach2_2","Geb_Liste","Filter","Eindeutig","Eind_Filt_Sort","Beispiel Umsätze","Zuf_Matrix","Sequenz_1","Sequenz_2","XVerw_1","XVerw_2","XVerw_Matrix","XVerweis2_1","XVerweis2_2","XVergleich"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sortieren_1","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,10,0,11],[30,13,30,18],[17,13,20,13],[17,14,20,18],[21,13,24,13],[21,14,24,18],[26,13,28,18],[29,13,29,18],[4,13,6,18],[7,13,9,18],[10,13,12,13],[10,14,12,18],[13,13,16,13],[13,14,16,18],[0,14,0,18]]}
[null,"Funktion Sortieren()",null,null,null,null,null,null,null,null,"Version 3.8\nZuletzt geändert:\n24.10.2024",null,null,"Verfügbare Funktionen:","Eindeutig, Filter_, Sequenz, Sortieren, Sortierennach, Sortierennach2, XVergleich, XVerweis, XVerweis2, Zufallsmatrix"]
[null,"Sortieren nach 1 Spalte (1 Sortierkriterium)"]
[]
[null,"Daten",null,null,null,null,null,"Sortierte Liste"]
[null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,{"$f":"$B$5","v":"Mitarbeiter"},{"$f":"$C$5","v":"Region"},{"$f":"$D$5","v":"Produkt"},{"$f":"$E$5","v":"Jahr"},{"$f":"$F$5","v":"Umsatz"},null,"Syntax"]
[null,"Becker","Süd","WWWz",2022,898.27,null,{"$f":"Sortieren($B$6:$F$25,5,-1)","v":"Schmidt"},"Nord","AA7-FX",2022,1656.22]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Maier","Ost","BPD-4",2021,1543.42]
[null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,"Lehmann","West","BPD-4",2021,1508.32,null,"= Sortieren ( Matrix; [Index]; [Reihenfolge]; [nach_Spalte] )"]
[null,"Maier","Ost","BPD-4",2021,1543.42,null,"Fischer","Ost","AA7-FX",2022,1417.52]
[null,"Müller","Nord","Stropo-2",2021,1336.78,null,"Müller","Nord","WWWz",2019,1367.92]
[null,"Wagner","Süd","Stropo-2",2019,1220.92,null,"Müller","Nord","AA7-FX",2022,1339.58,null,"Matrix","Matrix oder Bereich, die/der sortiert werden soll"]
[null,"Fischer","Ost","AA7-FX",2022,1417.52,null,"Müller","Nord","Stropo-2",2021,1336.78]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,"Lange","Ost","Stropo-2",2021,1314.91]
[null,"Wagner","Süd","WWWz",2022,1108.93,null,"Wagner","Süd","Stropo-2",2019,1220.92,null,"Index\n(optional)","Nummer der Zeile oder der Spalte,\nnach der sortiert werden soll\n(Standard: Nummer = 1)"]
[null,"Schneider","Nord","BPD-4",2020,768.82,null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"Müller","Nord","AA7-FX",2022,1339.58,null,"Wagner","Süd","WWWz",2022,1108.93]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Becker","Süd","WWWz",2022,898.27]
[null,"Fischer","Ost","Stropo-2",2021,839.87,null,"Schulze","Süd","WWWz",2019,896.72,null,"Reihenfolge\n(optional)","Sortierreihenfolge:\n 1  für aufsteigend (Standard)\n-1  für absteigend"]
[null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,"Schulze","Süd","AA7-FX",2020,887.72]
[null,"Lange","Ost","Stropo-2",2021,1314.91,null,"Fischer","Ost","Stropo-2",2021,839.87]
[null,"Schulze","Süd","WWWz",2019,896.72,null,"Becker","Süd","AA7-FX",2019,792.52]
[null,"Schulze","Süd","WWWz",2022,734.88,null,"Schneider","Nord","BPD-4",2020,768.82,null,"nach_Spalte\n(optional)","FALSCH  für senkrechtes Sortieren in der Zeile (Standard)\nWAHR   für waagerechtes Sortieren in der Spalte"]
[null,"Müller","Nord","WWWz",2019,1367.92,null,"Schulze","Süd","WWWz",2022,734.88]
[null,"Schulze","Süd","AA7-FX",2020,887.72,null,"Schäfer","West","Stropo-2",2019,699.42]
[null,"Becker","Süd","AA7-FX",2019,792.52,null,"Baumgarten","West","XLT-1",2022,665.54]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Die Syntax ist dieselbe wie bei der Funktion SORTIEREN für Excel 365."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Siehe auch:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"https://support.microsoft.com/de-de/office/sortieren-funktion-22f63bd0-ccc8-492f-953d-c20e8e44b86c"]

{"sheet":"Sort_Nach","index":1,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,13,6,20],[7,13,9,20],[10,13,12,13],[10,14,12,20],[13,13,16,13],[13,14,16,20],[30,13,32,18],[33,13,33,18],[34,13,34,20],[17,13,20,13],[17,14,20,20],[21,13,24,13],[21,14,24,20],[25,13,28,13],[25,14,28,20]]}
[null,"Funktion Sortierennach()",null,null,null,null,null,"Sortiert"]
[null,"Sortieren nach 3 Spalten (3 Sortierkriterien)",null,null,null,null,null,"1. nach Jahr (absteigend)"]
[null,null,null,null,null,null,null,"2. nach Produkt (aufsteigend)"]
[null,"Daten",null,null,null,null,null,"3. nach Mitarbeiter (aufsteigend)"]
[null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,{"$f":"$B$5","v":"Mitarbeiter"},{"$f":"$C$5","v":"Region"},{"$f":"$D$5","v":"Produkt"},{"$f":"$E$5","v":"Jahr"},{"$f":"$F$5","v":"Umsatz"},null,"Syntax"]
[null,"Becker","Süd","WWWz",2022,898.27,null,{"$f":"Sortierennach($B$6:$F$29,$E$6:$E$29,-1,$D$6:$D$29,1,$B$6:$B$29)","v":"Fischer"},"Ost","AA7-FX",2022,1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Müller","Nord","AA7-FX",2022,1339.58]
[null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,"= Sortierennach ( Matrix; [Nach_Matrix1]; [Reihenfolge1]; [Nach_Matrix2]; [Reihenfolge2]; … )"]
[null,"Maier","Ost","BPD-4",2021,1543.42,null,"Becker","Süd","WWWz",2022,898.27]
[null,"Müller","Nord","Stropo-2",2021,1336.78,null,"Schulze","Süd","WWWz",2022,734.88]
[null,"Wagner","Süd","Stropo-2",2019,1220.92,null,"Wagner","Süd","WWWz",2022,1108.93,null,"Matrix","Matrix oder Bereich, die/der sortiert werden soll"]
[null,"Fischer","Ost","AA7-FX",2022,1417.52,null,"Baumgarten","West","XLT-1",2022,665.54]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,"Lehmann","West","XLT-1",2022,926.99]
[null,"Wagner","Süd","WWWz",2022,1108.93,null,"Schneider","Nord","XLT-1",2022,1446.6,null,"Nach_Matrix1","Matrix oder Bereich,\nnach der/dem sortiert werden soll"]
[null,"Schneider","Nord","BPD-4",2020,768.82,null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"Müller","Nord","AA7-FX",2022,1339.58,null,"Lehmann","West","BPD-4",2021,1508.32]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Maier","Ost","BPD-4",2021,1543.42]
[null,"Fischer","Ost","Stropo-2",2021,839.87,null,"Fischer","Ost","Stropo-2",2021,839.87,null,"Reihenfolge1\n(optional)","Sortierreihenfolge:\n 1  für aufsteigend (Standard)\n-1  für absteigend"]
[null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,"Lange","Ost","Stropo-2",2021,1314.91]
[null,"Lange","Ost","Stropo-2",2021,1314.91,null,"Müller","Nord","Stropo-2",2021,1336.78]
[null,"Schulze","Süd","WWWz",2019,896.72,null,"Schmidt","Nord","WWWz",2021,1014]
[null,"Schulze","Süd","WWWz",2022,734.88,null,"Schneider","Nord","WWWz",2021,1083.9000000000001,null,"Nach_Matrix2\n(optional)","Matrix oder Bereich,\nnach der/dem sortiert werden soll"]
[null,"Müller","Nord","WWWz",2019,1367.92,null,"Schulze","Süd","AA7-FX",2020,887.72]
[null,"Schulze","Süd","AA7-FX",2020,887.72,null,"Schneider","Nord","BPD-4",2020,768.82]
[null,"Becker","Süd","AA7-FX",2019,792.52,null,"Becker","Süd","AA7-FX",2019,792.52]
[null,"Schmidt","Nord","WWWz",2021,1014,null,"Schäfer","West","Stropo-2",2019,699.42,null,"Reihenfolge2\n(optional)","Sortierreihenfolge:\n 1  für aufsteigend (Standard)\n-1  für absteigend"]
[null,"Schneider","Nord","XLT-1",2022,1446.6,null,"Wagner","Süd","Stropo-2",2019,1220.92]
[null,"Lehmann","West","XLT-1",2022,926.99,null,"Müller","Nord","WWWz",2019,1367.92]
[null,"Schneider","Nord","WWWz",2021,1083.9000000000001,null,"Schulze","Süd","WWWz",2019,896.72]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Die Syntax ist dieselbe wie bei der Funktion SORTIERENNACH für Excel 365."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Siehe auch:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"https://support.microsoft.com/de-de/office/sortierennach-funktion-cd2d7a62-1b93-435c-b561-d6a35134f28f"]

{"sheet":"Sortieren_2","index":2,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion Sortieren()"]
[null,"Sortieren nach mehreren Spaltennummern (mehrere Sortierkriterien)",null,null,null,null,null,null,null,null,null,null,null,4,2,1]
[]
[null,"Daten",null,null,null,null,null,"Sortiert nach Jahr und Umsatz",null,null,null,null,null,"Sortiert nach Jahr, Region und Mitarbeiter"]
[null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"Becker","Süd","WWWz",2022,898.27,null,{"$f":"Sortieren($B$6:$F$25,{4;5},{-1;1})","v":"Baumgarten"},"West","XLT-1",2022,665.54,null,{"$f":"Sortieren($B$6:$F$25,$N$2:$P$2,{-1;1;1})","v":"Müller"},"Nord","AA7-FX",2022,1339.58]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Schulze","Süd","WWWz",2022,734.88,null,"Schmidt","Nord","AA7-FX",2022,1656.22]
[null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,"Becker","Süd","WWWz",2022,898.27,null,"Fischer","Ost","AA7-FX",2022,1417.52]
[null,"Maier","Ost","BPD-4",2021,1543.42,null,"Wagner","Süd","WWWz",2022,1108.93,null,"Becker","Süd","WWWz",2022,898.27]
[null,"Müller","Nord","Stropo-2",2021,1336.78,null,"Müller","Nord","AA7-FX",2022,1339.58,null,"Schulze","Süd","WWWz",2022,734.88]
[null,"Wagner","Süd","Stropo-2",2019,1220.92,null,"Fischer","Ost","AA7-FX",2022,1417.52,null,"Wagner","Süd","WWWz",2022,1108.93]
[null,"Fischer","Ost","AA7-FX",2022,1417.52,null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,"Baumgarten","West","XLT-1",2022,665.54]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,"Fischer","Ost","Stropo-2",2021,839.87,null,"Müller","Nord","Stropo-2",2021,1336.78]
[null,"Wagner","Süd","WWWz",2022,1108.93,null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"Schneider","Nord","BPD-4",2020,768.82,null,"Lange","Ost","Stropo-2",2021,1314.91,null,"Fischer","Ost","Stropo-2",2021,839.87]
[null,"Müller","Nord","AA7-FX",2022,1339.58,null,"Müller","Nord","Stropo-2",2021,1336.78,null,"Lange","Ost","Stropo-2",2021,1314.91]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Lehmann","West","BPD-4",2021,1508.32,null,"Maier","Ost","BPD-4",2021,1543.42]
[null,"Fischer","Ost","Stropo-2",2021,839.87,null,"Maier","Ost","BPD-4",2021,1543.42,null,"Lehmann","West","BPD-4",2021,1508.32]
[null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,"Schneider","Nord","BPD-4",2020,768.82,null,"Schneider","Nord","BPD-4",2020,768.82]
[null,"Lange","Ost","Stropo-2",2021,1314.91,null,"Schulze","Süd","AA7-FX",2020,887.72,null,"Schulze","Süd","AA7-FX",2020,887.72]
[null,"Schulze","Süd","WWWz",2019,896.72,null,"Schäfer","West","Stropo-2",2019,699.42,null,"Müller","Nord","WWWz",2019,1367.92]
[null,"Schulze","Süd","WWWz",2022,734.88,null,"Becker","Süd","AA7-FX",2019,792.52,null,"Becker","Süd","AA7-FX",2019,792.52]
[null,"Müller","Nord","WWWz",2019,1367.92,null,"Schulze","Süd","WWWz",2019,896.72,null,"Schulze","Süd","WWWz",2019,896.72]
[null,"Schulze","Süd","AA7-FX",2020,887.72,null,"Wagner","Süd","Stropo-2",2019,1220.92,null,"Wagner","Süd","Stropo-2",2019,1220.92]
[null,"Becker","Süd","AA7-FX",2019,792.52,null,"Müller","Nord","WWWz",2019,1367.92,null,"Schäfer","West","Stropo-2",2019,699.42]

{"sheet":"Strukt_Verw","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,5]]}
[null,"Verwendung von\nstrukturierten Verweisen"]
[]
[]
[null,"Anzahl","Betrag",null,{"$f":"Fond[[#Headers],[Anzahl]]","v":"Anzahl"},{"$f":"Fond[[#Headers],[Betrag]]","v":"Betrag"}]
[null,5,100,null,{"$f":"Sortieren(Fond[])","v":2},50]
[null,12,100,null,3,200]
[null,3,200,null,5,100]
[null,6,200,null,6,200]
[null,21,10,null,12,100]
[null,2,50,null,21,10]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Sort_Nach2_1","index":4,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion Sortierennach2()",null,null,null,null,null,"Sortiert"]
[null,"Sortieren nach 3 Spalten (3 Sortierkriterien)",null,null,null,null,null,"1. nach Jahr (absteigend)"]
[null,null,null,null,null,null,null,"2. nach Produkt (aufsteigend)"]
[null,"Daten",null,null,null,null,null,"3. nach Mitarbeiter (aufsteigend)"]
[null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,"Jahr","Produkt","Mitarbeiter","Region",{"$f":"$F$5","v":"Umsatz"}]
[null,"Becker","Süd","WWWz",2022,898.27,null,{"$f":"Sortierennach2($B$6:$F$29,$E$6:$E$29,-1,$D$6:$D$29,1,$B$6:$B$29)","v":2022},"AA7-FX","Fischer","Ost",1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,2022,"AA7-FX","Müller","Nord",1339.58]
[null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,2022,"AA7-FX","Schmidt","Nord",1656.22]
[null,"Maier","Ost","BPD-4",2021,1543.42,null,2022,"WWWz","Becker","Süd",898.27]
[null,"Müller","Nord","Stropo-2",2021,1336.78,null,2022,"WWWz","Schulze","Süd",734.88]
[null,"Wagner","Süd","Stropo-2",2019,1220.92,null,2022,"WWWz","Wagner","Süd",1108.93]
[null,"Fischer","Ost","AA7-FX",2022,1417.52,null,2022,"XLT-1","Baumgarten","West",665.54]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,2022,"XLT-1","Lehmann","West",926.99]
[null,"Wagner","Süd","WWWz",2022,1108.93,null,2022,"XLT-1","Schneider","Nord",1446.6]
[null,"Schneider","Nord","BPD-4",2020,768.82,null,2021,"AA7-FX","Schneider","Nord",1129.6199999999999]
[null,"Müller","Nord","AA7-FX",2022,1339.58,null,2021,"BPD-4","Lehmann","West",1508.32]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,2021,"BPD-4","Maier","Ost",1543.42]
[null,"Fischer","Ost","Stropo-2",2021,839.87,null,2021,"Stropo-2","Fischer","Ost",839.87]
[null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,2021,"Stropo-2","Lange","Ost",1314.91]
[null,"Lange","Ost","Stropo-2",2021,1314.91,null,2021,"Stropo-2","Müller","Nord",1336.78]
[null,"Schulze","Süd","WWWz",2019,896.72,null,2021,"WWWz","Schmidt","Nord",1014]
[null,"Schulze","Süd","WWWz",2022,734.88,null,2021,"WWWz","Schneider","Nord",1083.9000000000001]
[null,"Müller","Nord","WWWz",2019,1367.92,null,2020,"AA7-FX","Schulze","Süd",887.72]
[null,"Schulze","Süd","AA7-FX",2020,887.72,null,2020,"BPD-4","Schneider","Nord",768.82]
[null,"Becker","Süd","AA7-FX",2019,792.52,null,2019,"AA7-FX","Becker","Süd",792.52]
[null,"Schmidt","Nord","WWWz",2021,1014,null,2019,"Stropo-2","Schäfer","West",699.42]
[null,"Schneider","Nord","XLT-1",2022,1446.6,null,2019,"Stropo-2","Wagner","Süd",1220.92]
[null,"Lehmann","West","XLT-1",2022,926.99,null,2019,"WWWz","Müller","Nord",1367.92]
[null,"Schneider","Nord","WWWz",2021,1083.9000000000001,null,2019,"WWWz","Schulze","Süd",896.72]

{"sheet":"Sort_Nach2_2","index":5,"n_rows":105,"n_cols":13,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion Sortierennach2()",null,null,null,null,null,null,"1.\nSortier-\nkriterium","2.\nSortier-\nkriterium","3.\nSortier-\nkriterium","4.\nSortier-\nkriterium","5.\nSortier-\nkriterium"]
[null,"Sortieren nach 5 Spalten (5 Sortierkriterien)",null,null,null,null,null,"Sortiert nach:","Jahr","Region","Produkt","Mitarbeiter","Umsatz"]
[null,"mit freier Auswahl",null,null,null,null,null,null,"absteigend","aufsteigend","aufsteigend","aufsteigend","absteigend"]
[]
[null,"Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,null,{"$f":"$I$2","v":"Jahr"},{"$f":"$J$2","v":"Region"},{"$f":"$K$2","v":"Produkt"},{"$f":"$L$2","v":"Mitarbeiter"},{"$f":"$M$2","v":"Umsatz"}]
[null,"Becker","Süd","WWWz",2022,898.27,null,null,{"$f":"Sortierennach2($B$6:$F$105,OFFSET($B$6,0,MATCH($I$2,$B$5:$F$5,0)-1,100,1),IF($I$3=\"absteigend\",-1,1),OFFSET($B$6,0,MATCH($J$2,$B$5:$F$5,0)-1,100,1),IF($J$3=\"absteigend\",-1,1),OFFSET($B$6,0,MATCH($K$2,$B$5:$F$5,0)-1,100,1),IF($K$3=\"absteigend\",-1,1),OFFSET($B$6,0,MATCH($L$2,$B$5:$F$5,0)-1,100,1),IF($L$3=\"absteigend\",-1,1),OFFSET($B$6,0,MATCH($M$2,$B$5:$F$5,0)-1,100,1),IF($M$3=\"absteigend\",-1,1))","v":2022},"Nord","AA7-FX","Müller",1339.58]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,null,2022,"Nord","AA7-FX","Schmidt",1656.22]
[null,"Schmidt","Nord","AA7-FX",2022,1656.22,null,null,2022,"Nord","AA7-FX","Schneider",925.51]
[null,"Maier","Ost","BPD-4",2021,1543.42,null,null,2022,"Nord","XLT-1","Müller",1868.11]
[null,"Müller","Nord","Stropo-2",2021,1336.78,null,null,2022,"Nord","XLT-1","Schmidt",1165.8399999999999]
[null,"Wagner","Süd","Stropo-2",2019,1220.92,null,null,2022,"Nord","XLT-1","Schneider",1446.6]
[null,"Fischer","Ost","AA7-FX",2022,1417.52,null,null,2022,"Ost","AA7-FX","Fischer",1417.52]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,null,2022,"Ost","XLT-1","Fischer",793.99]
[null,"Wagner","Süd","WWWz",2022,1108.93,null,null,2022,"Ost","XLT-1","Lange",955.55]
[null,"Schneider","Nord","BPD-4",2020,768.82,null,null,2022,"Ost","XLT-1","Maier",1637.66]
[null,"Müller","Nord","AA7-FX",2022,1339.58,null,null,2022,"Süd","WWWz","Becker",898.27]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,null,2022,"Süd","WWWz","Schulze",734.88]
[null,"Fischer","Ost","Stropo-2",2021,839.87,null,null,2022,"Süd","WWWz","Wagner",1108.93]
[null,"Schneider","Nord","AA7-FX",2021,1129.6199999999999,null,null,2022,"Süd","XLT-1","Becker",1244.43]
[null,"Lange","Ost","Stropo-2",2021,1314.91,null,null,2022,"Süd","XLT-1","Schulze",1084.07]
[null,"Schulze","Süd","WWWz",2019,896.72,null,null,2022,"Süd","XLT-1","Wagner",1097.5999999999999]
[null,"Schulze","Süd","WWWz",2022,734.88,null,null,2022,"West","WWWz","Baumgarten",848.1]
[null,"Müller","Nord","WWWz",2019,1367.92,null,null,2022,"West","WWWz","Lehmann",562.45000000000005]
[null,"Schulze","Süd","AA7-FX",2020,887.72,null,null,2022,"West","WWWz","Schäfer",1016.32]
[null,"Becker","Süd","AA7-FX",2019,792.52,null,null,2022,"West","XLT-1","Baumgarten",665.54]
[null,"Schmidt","Nord","WWWz",2021,1014,null,null,2022,"West","XLT-1","Lehmann",926.99]
[null,"Schneider","Nord","XLT-1",2022,1446.6,null,null,2022,"West","XLT-1","Schäfer",1134.8399999999999]
[null,"Lehmann","West","XLT-1",2022,926.99,null,null,2021,"Nord","AA7-FX","Schneider",1129.6199999999999]
[null,"Schneider","Nord","WWWz",2021,1083.9000000000001,null,null,2021,"Nord","BPD-4","Müller",1185.42]
[null,"Becker","Süd","XLT-1",2020,1305.32,null,null,2021,"Nord","BPD-4","Schmidt",1280.02]
[null,"Schäfer","West","BPD-4",2021,696.92,null,null,2021,"Nord","Stropo-2","Müller",1336.78]
[null,"Müller","Nord","BPD-4",2021,1185.42,null,null,2021,"Nord","Stropo-2","Schmidt",1323.24]
[null,"Schmidt","Nord","WWWz",2019,907.42,null,null,2021,"Nord","Stropo-2","Schneider",636.59]
[null,"Maier","Ost","XLT-1",2020,1549.92,null,null,2021,"Nord","WWWz","Müller",1624]
[null,"Schneider","Nord","AA7-FX",2022,925.51,null,null,2021,"Nord","WWWz","Schmidt",1014]
[null,"Maier","Ost","WWWz",2021,1082.8399999999999,null,null,2021,"Nord","WWWz","Schneider",1083.9000000000001]
[null,"Lehmann","West","Stropo-2",2019,1577.22,null,null,2021,"Ost","BPD-4","Fischer",1019.52]
[null,"Lange","Ost","WWWz",2021,828.17,null,null,2021,"Ost","BPD-4","Lange",921.62]
[null,"Maier","Ost","XLT-1",2022,1637.66,null,null,2021,"Ost","BPD-4","Maier",1543.42]
[null,"Baumgarten","West","WWWz",2022,848.1,null,null,2021,"Ost","Stropo-2","Fischer",839.87]
[null,"Schulze","Süd","XLT-1",2022,1084.07,null,null,2021,"Ost","Stropo-2","Lange",1314.91]
[null,"Baumgarten","West","AA7-FX",2020,989.92,null,null,2021,"Ost","Stropo-2","Maier",1046.92]
[null,"Baumgarten","West","BPD-4",2021,1462.42,null,null,2021,"Ost","WWWz","Fischer",993.58]
[null,"Schneider","Nord","XLT-1",2020,1581.02,null,null,2021,"Ost","WWWz","Lange",828.17]
[null,"Schulze","Süd","XLT-1",2020,1136.52,null,null,2021,"Ost","WWWz","Maier",1082.8399999999999]
[null,"Schulze","Süd","Stropo-2",2019,831.72,null,null,2021,"Süd","BPD-4","Becker",980.52]
[null,"Lehmann","West","Stropo-2",2021,1890.05,null,null,2021,"Süd","BPD-4","Schulze",667.42]
[null,"Fischer","Ost","AA7-FX",2020,1275.02,null,null,2021,"Süd","BPD-4","Wagner",661.92]
[null,"Becker","Süd","BPD-4",2021,980.52,null,null,2021,"Süd","Stropo-2","Becker",859.6]
[null,"Lange","Ost","WWWz",2019,684.82,null,null,2021,"Süd","Stropo-2","Schulze",809.39]
[null,"Lange","Ost","Stropo-2",2019,1498.32,null,null,2021,"Süd","Stropo-2","Wagner",1288.92]
[null,"Schmidt","Nord","AA7-FX",2020,1540.02,null,null,2021,"West","BPD-4","Baumgarten",1462.42]
[null,"Schäfer","West","WWWz",2019,861.52,null,null,2021,"West","BPD-4","Lehmann",1508.32]
[null,"Schmidt","Nord","XLT-1",2022,1165.8399999999999,null,null,2021,"West","BPD-4","Schäfer",696.92]
[null,"Schäfer","West","WWWz",2022,1016.32,null,null,2021,"West","Stropo-2","Baumgarten",760.93]
[null,"Fischer","Ost","XLT-1",2020,712.72,null,null,2021,"West","Stropo-2","Lehmann",1890.05]
[null,"Müller","Nord","Stropo-2",2019,1445.42,null,null,2021,"West","Stropo-2","Schäfer",748.37]
[null,"Lehmann","West","WWWz",2019,704.32,null,null,2020,"Nord","AA7-FX","Müller",1510.32]
[null,"Schäfer","West","AA7-FX",2020,1418.42,null,null,2020,"Nord","AA7-FX","Schmidt",1540.02]
[null,"Maier","Ost","Stropo-2",2019,992.62,null,null,2020,"Nord","BPD-4","Schneider",768.82]
[null,"Fischer","Ost","Stropo-2",2019,1005.02,null,null,2020,"Nord","XLT-1","Müller",1583.82]
[null,"Lehmann","West","WWWz",2022,562.45000000000005,null,null,2020,"Nord","XLT-1","Schmidt",1033.42]
[null,"Becker","Süd","Stropo-2",2019,1103.42,null,null,2020,"Nord","XLT-1","Schneider",1581.02]
[null,"Schneider","Nord","Stropo-2",2021,636.59,null,null,2020,"Ost","AA7-FX","Fischer",1275.02]
[null,"Maier","Ost","WWWz",2019,1347.42,null,null,2020,"Ost","AA7-FX","Lange",878.82]
[null,"Wagner","Süd","XLT-1",2022,1097.5999999999999,null,null,2020,"Ost","AA7-FX","Maier",1496.82]
[null,"Schäfer","West","Stropo-2",2021,748.37,null,null,2020,"Ost","XLT-1","Fischer",712.72]
[null,"Wagner","Süd","Stropo-2",2021,1288.92,null,null,2020,"Ost","XLT-1","Lange",906.42]
[null,"Lehmann","West","AA7-FX",2020,990.52,null,null,2020,"Ost","XLT-1","Maier",1549.92]
[null,"Wagner","Süd","BPD-4",2021,661.92,null,null,2020,"Süd","AA7-FX","Becker",991.12]
[null,"Müller","Nord","AA7-FX",2020,1510.32,null,null,2020,"Süd","AA7-FX","Schulze",887.72]
[null,"Fischer","Ost","BPD-4",2021,1019.52,null,null,2020,"Süd","AA7-FX","Wagner",1029.82]
[null,"Fischer","Ost","WWWz",2019,975.82,null,null,2020,"Süd","XLT-1","Becker",1305.32]
[null,"Lange","Ost","AA7-FX",2020,878.82,null,null,2020,"Süd","XLT-1","Schulze",1136.52]
[null,"Lange","Ost","XLT-1",2020,906.42,null,null,2020,"Süd","XLT-1","Wagner",943.52]
[null,"Wagner","Süd","XLT-1",2020,943.52,null,null,2020,"West","AA7-FX","Baumgarten",989.92]
[null,"Müller","Nord","WWWz",2021,1624,null,null,2020,"West","AA7-FX","Lehmann",990.52]
[null,"Becker","Süd","Stropo-2",2021,859.6,null,null,2020,"West","AA7-FX","Schäfer",1418.42]
[null,"Fischer","Ost","XLT-1",2022,793.99,null,null,2020,"West","WWWz","Baumgarten",982.32]
[null,"Schneider","Nord","WWWz",2019,924.82,null,null,2020,"West","XLT-1","Baumgarten",659.82]
[null,"Müller","Nord","XLT-1",2022,1868.11,null,null,2020,"West","XLT-1","Lehmann",1206.82]
[null,"Fischer","Ost","WWWz",2021,993.58,null,null,2020,"West","XLT-1","Schäfer",1562.62]
[null,"Schäfer","West","XLT-1",2022,1134.8399999999999,null,null,2019,"Nord","Stropo-2","Müller",1445.42]
[null,"Maier","Ost","Stropo-2",2021,1046.92,null,null,2019,"Nord","Stropo-2","Schmidt",1275.72]
[null,"Wagner","Süd","WWWz",2019,1140.52,null,null,2019,"Nord","Stropo-2","Schneider",850.12]
[null,"Baumgarten","West","WWWz",2020,982.32,null,null,2019,"Nord","WWWz","Müller",1367.92]
[null,"Becker","Süd","XLT-1",2022,1244.43,null,null,2019,"Nord","WWWz","Schmidt",907.42]
[null,"Lehmann","West","XLT-1",2020,1206.82,null,null,2019,"Nord","WWWz","Schneider",924.82]
[null,"Schäfer","West","XLT-1",2020,1562.62,null,null,2019,"Ost","Stropo-2","Fischer",1005.02]
[null,"Lange","Ost","XLT-1",2022,955.55,null,null,2019,"Ost","Stropo-2","Lange",1498.32]
[null,"Schneider","Nord","Stropo-2",2019,850.12,null,null,2019,"Ost","Stropo-2","Maier",992.62]
[null,"Maier","Ost","AA7-FX",2020,1496.82,null,null,2019,"Ost","WWWz","Fischer",975.82]
[null,"Schulze","Süd","BPD-4",2021,667.42,null,null,2019,"Ost","WWWz","Lange",684.82]
[null,"Schmidt","Nord","BPD-4",2021,1280.02,null,null,2019,"Ost","WWWz","Maier",1347.42]
[null,"Baumgarten","West","Stropo-2",2019,1022.82,null,null,2019,"Süd","AA7-FX","Becker",792.52]
[null,"Wagner","Süd","AA7-FX",2020,1029.82,null,null,2019,"Süd","Stropo-2","Becker",1103.42]
[null,"Baumgarten","West","XLT-1",2020,659.82,null,null,2019,"Süd","Stropo-2","Schulze",831.72]
[null,"Müller","Nord","XLT-1",2020,1583.82,null,null,2019,"Süd","Stropo-2","Wagner",1220.92]
[null,"Becker","Süd","AA7-FX",2020,991.12,null,null,2019,"Süd","WWWz","Schulze",896.72]
[null,"Schulze","Süd","Stropo-2",2021,809.39,null,null,2019,"Süd","WWWz","Wagner",1140.52]
[null,"Lange","Ost","BPD-4",2021,921.62,null,null,2019,"West","Stropo-2","Baumgarten",1022.82]
[null,"Schmidt","Nord","Stropo-2",2019,1275.72,null,null,2019,"West","Stropo-2","Lehmann",1577.22]
[null,"Schmidt","Nord","Stropo-2",2021,1323.24,null,null,2019,"West","Stropo-2","Schäfer",699.42]
[null,"Schmidt","Nord","XLT-1",2020,1033.42,null,null,2019,"West","WWWz","Lehmann",704.32]
[null,"Baumgarten","West","Stropo-2",2021,760.93,null,null,2019,"West","WWWz","Schäfer",861.52]

{"sheet":"Geb_Liste","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Geburtstagsliste"]
[]
[null,"Name","Geburtsdatum",null,"Geburtstag","Name"]
[null,"Wagner","1950-06-14",null,{"$f":"Sortieren(CHOOSE({1,2},DATE(,MONTH(C4:C10),DAY(C4:C10)),$B$4:$B$10))","v":"1900-01-03"},"Lange"]
[null,"Schneider","1977-07-23",null,"1900-02-01","Fischer"]
[null,"Müller","2001-03-04",null,"1900-03-04","Müller"]
[null,"Schäfer","2014-08-15",null,"1900-06-14","Wagner"]
[null,"Fischer","1967-02-01",null,"1900-07-23","Schneider"]
[null,"Schneider","2001-12-22",null,"1900-08-15","Schäfer"]
[null,"Lange","1982-01-03",null,"1900-12-22","Schneider"]

{"sheet":"Filter","index":7,"n_rows":25,"n_cols":25,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[null,"Funktion Filter_()",null,null,null,null,"Bsp. 1",null,null,null,null,"Bsp. 2",null,null,null,null,"Bsp. 3",null,null,null,null,"Bsp. 4"]
[null,"Filtern von Daten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zweimaliges Filtern (verschachtelt):"]
[null,"Der Unterstrich gehört mit zum Funktionsnamen!",null,null,null,null,"Waagerechtes Filtern:",null,null,null,null,"Senkrechtes Filtern:",null,null,null,null,"Kombination mit Sortieren:",null,null,null,null,"1.  Nach Spaltenüberschriften (waagerecht)"]
[null,"Daten",null,null,null,null,"Gefiltert nach Spaltenüberschriften",null,null,null,null,"Nur Umsätze zwischen 1000 und 1500",null,null,null,null,"Wie letzte Tabelle, aber zusätzlich nach Umsatz sortiert",null,null,null,null,"2.  Nach Umsatz > 1000  (senkrecht)"]
[null,"Mitarbeiter","Region","Produkt","Umsatz",null,{"$f":"Filter_(B5:E25,(B5:E5=\"Region\")+(B5:E5=\"Umsatz\"))","v":"Region"},"Umsatz","","",null,"Mitarbeiter","Region","Produkt","Umsatz",null,"Mitarbeiter","Region","Produkt","Umsatz",null,{"$f":"Filter_(Filter_(B5:E25,(B5:E5=\"Region\")+(B5:E5=\"Umsatz\")),E5:E25>1000)","v":"Region"},"Umsatz","",""]
[null,"Becker","Süd","WWWz",898.27,null,"Süd",898.27,"","",null,{"$f":"Filter_(B6:E25,(E6:E25>1000)*(E6:E25<1500),\"no data\")","v":"Müller"},"Nord","Stropo-2",1336.78,null,{"$f":"Sortieren(Filter_(B6:E25,(E6:E25>1000)*(E6:E25<1500)),4,-1)","v":"Fischer"},"Ost","AA7-FX",1417.52,null,"West",1508.32,"",""]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",1508.32,"","",null,"Wagner","Süd","Stropo-2",1220.92,null,"Müller","Nord","WWWz",1367.92,null,"Nord",1656.22,"",""]
[null,"Schmidt","Nord","AA7-FX",1656.22,null,"Nord",1656.22,"","",null,"Fischer","Ost","AA7-FX",1417.52,null,"Müller","Nord","AA7-FX",1339.58,null,"Ost",1543.42,"",""]
[null,"Maier","Ost","BPD-4",1543.42,null,"Ost",1543.42,"","",null,"Wagner","Süd","WWWz",1108.93,null,"Müller","Nord","Stropo-2",1336.78,null,"Nord",1336.78,"",""]
[null,"Müller","Nord","Stropo-2",1336.78,null,"Nord",1336.78,"","",null,"Müller","Nord","AA7-FX",1339.58,null,"Lange","Ost","Stropo-2",1314.91,null,"Süd",1220.92,"",""]
[null,"Wagner","Süd","Stropo-2",1220.92,null,"Süd",1220.92,"","",null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"Wagner","Süd","Stropo-2",1220.92,null,"Ost",1417.52,"",""]
[null,"Fischer","Ost","AA7-FX",1417.52,null,"Ost",1417.52,"","",null,"Lange","Ost","Stropo-2",1314.91,null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"Süd",1108.93,"",""]
[null,"Baumgarten","West","XLT-1",665.54,null,"West",665.54,"","",null,"Müller","Nord","WWWz",1367.92,null,"Wagner","Süd","WWWz",1108.93,null,"Nord",1339.58,"",""]
[null,"Wagner","Süd","WWWz",1108.93,null,"Süd",1108.93,"","",null,"","","","",null,"","","","",null,"Nord",1129.6199999999999,"",""]
[null,"Schneider","Nord","BPD-4",768.82,null,"Nord",768.82,"","",null,"","","","",null,"","","","",null,"Ost",1314.91,"",""]
[null,"Müller","Nord","AA7-FX",1339.58,null,"Nord",1339.58,"","",null,"","","","",null,"","","","",null,"Nord",1367.92,"",""]
[null,"Schäfer","West","Stropo-2",699.42,null,"West",699.42,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Fischer","Ost","Stropo-2",839.87,null,"Ost",839.87,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"Nord",1129.6199999999999,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Lange","Ost","Stropo-2",1314.91,null,"Ost",1314.91,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","Süd","WWWz",896.72,null,"Süd",896.72,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","Süd","WWWz",734.88,null,"Süd",734.88,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Müller","Nord","WWWz",1367.92,null,"Nord",1367.92,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","Süd","AA7-FX",887.72,null,"Süd",887.72,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Becker","Süd","AA7-FX",792.52,null,"Süd",792.52,"","",null,"","","","",null,"","","","",null,"","","",""]

{"sheet":"Eindeutig","index":8,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,6,4,6],[2,12,4,13],[1,10,4,10],[1,8,4,8]]}
[null,"Funktion Eindeutig()"]
[null,"Duplikate nur einmal aufführen",null,null,null,null,null,null,"Welche Produkte gibt es?\n (sortiert)",null,"Welche Mitarbeiter kommen nur einmal vor?"]
[null,"oder auch einmalig vorkommende heraussuchen",null,null,null,null,"Welche Regionen gibt es?",null,null,null,null,null,"Welche Kombinationen aus Mitarbeitern und Regionen gibt es?"]
[]
[null,"Daten"]
[null,"Mitarbeiter","Region","Produkt","Umsatz",null,"Regionen",null,"Produkte",null,"Mitarbeiter",null,"Mitarbeiter","Region"]
[null,"Becker","Süd","WWWz",898.27,null,{"$f":"Eindeutig($C$7:$C$26)","v":"Süd"},null,{"$f":"Sortieren(Eindeutig($D$7:$D$26))","v":"AA7-FX"},null,{"$f":"Eindeutig($B$7:$B$26,,TRUE)","v":"Lehmann"},null,{"$f":"Eindeutig($B$7:$C$26)","v":"Becker"},"Süd"]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",null,"BPD-4",null,"Schmidt",null,"Lehmann","West"]
[null,"Schmidt","Nord","AA7-FX",1656.22,null,"Nord",null,"Stropo-2",null,"Maier",null,"Schmidt","Nord"]
[null,"Maier","Ost","BPD-4",1543.42,null,"Ost",null,"WWWz",null,"Baumgarten",null,"Maier","Ost"]
[null,"Müller","Nord","Stropo-2",1336.78,null,"",null,"XLT-1",null,"Schäfer",null,"Müller","Nord"]
[null,"Wagner","Süd","Stropo-2",1220.92,null,"",null,"",null,"Lange",null,"Wagner","Süd"]
[null,"Fischer","Ost","AA7-FX",1417.52,null,"",null,"",null,"",null,"Fischer","Ost"]
[null,"Baumgarten","West","XLT-1",665.54,null,"",null,"",null,"",null,"Baumgarten","West"]
[null,"Wagner","Süd","WWWz",1108.93,null,"",null,"",null,"",null,"Schneider","Nord"]
[null,"Schneider","Nord","BPD-4",768.82,null,"",null,"",null,"",null,"Schäfer","West"]
[null,"Müller","Nord","AA7-FX",1339.58,null,"",null,"",null,"",null,"Lange","Ost"]
[null,"Schäfer","West","Stropo-2",699.42,null,"",null,"",null,"",null,"Schulze","Süd"]
[null,"Fischer","Ost","Stropo-2",839.87,null,"",null,"",null,"",null,"",""]
[null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"",null,"",null,"",null,"",""]
[null,"Lange","Ost","Stropo-2",1314.91,null,"",null,"",null,"",null,"",""]
[null,"Schulze","Süd","WWWz",896.72,null,"",null,"",null,"",null,"",""]
[null,"Schulze","Süd","WWWz",734.88,null,"",null,"",null,"",null,"",""]
[null,"Müller","Nord","WWWz",1367.92,null,"",null,"",null,"",null,"",""]
[null,"Schulze","Süd","AA7-FX",887.72,null,"",null,"",null,"",null,"",""]
[null,"Becker","Süd","AA7-FX",792.52,null,"",null,"",null,"",null,"",""]

{"sheet":"Eind_Filt_Sort","index":9,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,6,4,6],[1,1,2,5],[0,13,0,14],[0,16,0,17],[0,19,0,20],[1,10,3,11],[4,10,4,11],[1,13,3,14],[4,13,4,14],[1,16,3,17],[4,16,4,17],[1,19,3,20],[4,19,4,20]]}
[null,"Kombination Eindeutig, Filter_, Sortieren",null,null,null,null,null,null,null,null,null,null,null,"1. Zwischenschritt:",null,null,"2. Zwischenschritt:",null,null,"Finale Lösung:"]
[null,"und strukturierte Verweise",null,null,null,null,null,null,"Mitarbeiter",null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?",null,null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?",null,null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?",null,null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?"]
[null,null,null,null,null,null,"Welche Regionen gibt es?",null,"der Region"]
[null,null,null,null,null,null,null,null,"Süd"]
[null,"Daten",null,null,null,null,null,null,null,null,"Sortiert nach Mitarbeitern",null,null,"Sortiert nach Umsatz",null,null,"Sortiert nach Umsatz",null,null,"Sortiert nach Umsatz"]
[null,"Mitarbeiter","Region","Produkt","Umsatz",null,"Regionen",null,"Mitarbeiter",null,"Mitarbeiter","Umsatz",null,"Mitarbeiter","Umsatz",null,"Mitarbeiter","Umsatz",null,"Mitarbeiter","Umsatz"]
[null,"Becker","Süd","WWWz",898.27,null,{"$f":"Eindeutig(Tabelle[Region])","v":"Süd"},null,{"$f":"Sortieren(Eindeutig(Filter_(Tabelle[Mitarbeiter],Tabelle[Region]=$I$4)))","v":"Becker"},null,{"$f":"Sortieren(Eindeutig($B$7:$B$26))","v":"Baumgarten"},{"$f":"IF(K7:K26=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,K7:K26))","v":665.54},null,{"$f":"Eindeutig($B$7:$B$26)","v":"Becker"},{"$f":"IF(N7:N26=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,N7:N26))","v":1690.79},null,{"$f":"Sortieren(CHOOSE({1,2},$N$7:$N$26,$O$7:$O$26),2,-1)","v":"Müller"},4044.2799999999997,null,{"$f":"Sortieren(CHOOSE({1,2},Eindeutig($B$7:$B$26),IF(Eindeutig($B$7:$B$26)=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,Eindeutig($B$7:$B$26)))),2,-1)","v":"Müller"},4044.2799999999997]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",null,"Müller",null,"Becker",1690.79,null,"Lehmann",1508.32,null,"Schulze",2519.3199999999997,null,"Schulze",2519.3199999999997]
[null,"Schmidt","Nord","AA7-FX",1656.22,null,"Nord",null,"Schäfer",null,"Fischer",2257.39,null,"Schmidt",1656.22,null,"Wagner",2329.8500000000004,null,"Wagner",2329.8500000000004]
[null,"Maier","Ost","BPD-4",1543.42,null,"Ost",null,"Schulze",null,"Lange",1314.91,null,"Maier",1543.42,null,"Fischer",2257.39,null,"Fischer",2257.39]
[null,"Müller","Nord","Stropo-2",1336.78,null,"",null,"Wagner",null,"Lehmann",1508.32,null,"Müller",4044.2799999999997,null,"Schneider",1898.44,null,"Schneider",1898.44]
[null,"Wagner","Süd","Stropo-2",1220.92,null,"",null,"",null,"Maier",1543.42,null,"Wagner",2329.8500000000004,null,"Becker",1690.79,null,"Becker",1690.79]
[null,"Fischer","Ost","AA7-FX",1417.52,null,"",null,"",null,"Müller",4044.2799999999997,null,"Fischer",2257.39,null,"Schmidt",1656.22,null,"Schmidt",1656.22]
[null,"Baumgarten","West","XLT-1",665.54,null,"",null,"",null,"Schäfer",699.42,null,"Baumgarten",665.54,null,"Maier",1543.42,null,"Maier",1543.42]
[null,"Wagner","Süd","WWWz",1108.93,null,"",null,"",null,"Schmidt",1656.22,null,"Schneider",1898.44,null,"Lehmann",1508.32,null,"Lehmann",1508.32]
[null,"Schneider","Nord","BPD-4",768.82,null,"",null,"",null,"Schneider",1898.44,null,"Schäfer",699.42,null,"Lange",1314.91,null,"Lange",1314.91]
[null,"Müller","Süd","AA7-FX",1339.58,null,"",null,"",null,"Schulze",2519.3199999999997,null,"Lange",1314.91,null,"Schäfer",699.42,null,"Schäfer",699.42]
[null,"Schäfer","Süd","Stropo-2",699.42,null,"",null,"",null,"Wagner",2329.8500000000004,null,"Schulze",2519.3199999999997,null,"Baumgarten",665.54,null,"Baumgarten",665.54]
[null,"Fischer","Ost","Stropo-2",839.87,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Lange","Ost","Stropo-2",1314.91,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Schulze","Süd","WWWz",896.72,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Schulze","Süd","WWWz",734.88,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Müller","Nord","WWWz",1367.92,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Schulze","Süd","AA7-FX",887.72,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]
[null,"Becker","Süd","AA7-FX",792.52,null,"",null,"",null,"","",null,"","",null,"","",null,"",""]

{"sheet":"Beispiel Umsätze","index":10,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,2,5],[1,6,3,7],[1,9,3,10],[4,6,4,7],[2,13,2,19],[4,13,4,15],[4,16,4,18],[4,9,4,10],[0,9,0,10]]}
[null,"Beispiel: Gesamtumsätze aller Mitarbeiter"]
[null,"Kombination Eindeutig u. Sortieren",null,null,null,null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?",null,null,"Welchen Umsatz hat jeder Mitarbeiter insgesamt gemacht?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Konventionelle Lösung für die Gesamtumsätze aller Mitarbeiter"]
[]
[null,"Daten",null,null,null,null,"Sortiert nach Mitarbeitern",null,null,"Sortiert nach Umsatz",null,null,null,"EINDEUTIG",null,null,"SORTIEREN"]
[null,"Mitarbeiter","Region","Produkt","Umsatz",null,"Mitarbeiter","Umsatz",null,"Mitarbeiter","Umsatz",null,null,null,null,null,null,null,"Mitarbeiter","Umsatz"]
[null,"Becker","Süd","WWWz",898.27,null,{"$f":"Sortieren(Eindeutig($B$7:$B$26))","v":"Baumgarten"},{"$f":"IF(G7:G26=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,G7:G26))","v":665.54},null,{"$f":"Sortieren(CHOOSE({1,2},Eindeutig($B$7:$B$26),IF(Eindeutig($B$7:$B$26)=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,Eindeutig($B$7:$B$26)))),2,-1)","v":"Müller"},4044.2799999999997,null,null,{"$f":"COUNTIF($B$7:$B7,$B7)+ROW()/10000","v":1.0006999999999999},{"$f":"SMALL(N$7:N$26,ROW(A1))","v":1.0006999999999999},{"$f":"IF(O7>2,\"\",INDEX($B$7:$B$26,MATCH(O7,$N$7:$N$26,0)))","v":"Becker"},{"$f":"COUNTIF($P$7:$P$26,\"<=\"&$P7)+ROW()*0.0001+($P7=\"\")*10000","v":10.0007},{"$f":"SMALL(Q$7:Q$26,ROW(A1))","v":9.0014000000000003},{"$f":"INDEX($P$7:$P$26,MATCH(R7,$Q$7:$Q$26,0))","v":"Baumgarten"},{"$f":"IF(S7=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,S7))","v":665.54}]
[null,"Lehmann","West","BPD-4",1508.32,null,"Becker",1690.79,null,"Schulze",2519.3199999999997,null,null,{"$f":"COUNTIF($B$7:$B8,$B8)+ROW()/10000","v":1.0007999999999999},1.0007999999999999,"Lehmann",{"$f":"COUNTIF($P$7:$P$26,\"<=\"&$P8)+ROW()*0.0001+($P8=\"\")*10000","v":13.0008},10.0007,"Becker",{"$f":"IF(S8=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,S8))","v":1690.79}]
[null,"Schmidt","Nord","AA7-FX",1656.22,null,"Fischer",2257.39,null,"Wagner",2329.8500000000004,null,null,{"$f":"COUNTIF($B$7:$B9,$B9)+ROW()/10000","v":1.0008999999999999},1.0008999999999999,"Schmidt",17.000900000000001,11.001300000000001,"Fischer",2257.39]
[null,"Maier","Ost","BPD-4",1543.42,null,"Lange",1314.91,null,"Fischer",2257.39,null,null,{"$f":"COUNTIF($B$7:$B10,$B10)+ROW()/10000","v":1.0009999999999999},1.0009999999999999,"Maier",14.000999999999999,12.0017,"Lange",1314.91]
[null,"Müller","Nord","Stropo-2",1336.78,null,"Lehmann",1508.32,null,"Schneider",1898.44,null,null,{"$f":"COUNTIF($B$7:$B11,$B11)+ROW()/10000","v":1.0011000000000001},1.0011000000000001,"Müller",15.001099999999999,13.0008,"Lehmann",1508.32]
[null,"Wagner","Süd","Stropo-2",1220.92,null,"Maier",1543.42,null,"Becker",1690.79,null,null,{"$f":"COUNTIF($B$7:$B12,$B12)+ROW()/10000","v":1.0012000000000001},1.0012000000000001,"Wagner",20.001200000000001,14.000999999999999,"Maier",1543.42]
[null,"Fischer","Ost","AA7-FX",1417.52,null,"Müller",4044.2799999999997,null,"Schmidt",1656.22,null,null,{"$f":"COUNTIF($B$7:$B13,$B13)+ROW()/10000","v":1.0013000000000001},1.0013000000000001,"Fischer",11.001300000000001,15.001099999999999,"Müller",4044.2799999999997]
[null,"Baumgarten","West","XLT-1",665.54,null,"Schäfer",699.42,null,"Maier",1543.42,null,null,{"$f":"COUNTIF($B$7:$B14,$B14)+ROW()/10000","v":1.0014000000000001},1.0014000000000001,"Baumgarten",9.0014000000000003,16.0016,"Schäfer",699.42]
[null,"Wagner","Süd","WWWz",1108.93,null,"Schmidt",1656.22,null,"Lehmann",1508.32,null,null,{"$f":"COUNTIF($B$7:$B15,$B15)+ROW()/10000","v":2.0015000000000001},1.0016,"Schneider",18.0015,17.000900000000001,"Schmidt",1656.22]
[null,"Schneider","Nord","BPD-4",768.82,null,"Schneider",1898.44,null,"Lange",1314.91,null,null,{"$f":"COUNTIF($B$7:$B16,$B16)+ROW()/10000","v":1.0016},1.0018,"Schäfer",16.0016,18.0015,"Schneider",1898.44]
[null,"Müller","Süd","AA7-FX",1339.58,null,"Schulze",2519.3199999999997,null,"Schäfer",699.42,null,null,{"$f":"COUNTIF($B$7:$B17,$B17)+ROW()/10000","v":2.0017},1.0021,"Lange",12.0017,19.001799999999999,"Schulze",2519.3199999999997]
[null,"Schäfer","Süd","Stropo-2",699.42,null,"Wagner",2329.8500000000004,null,"Baumgarten",665.54,null,null,{"$f":"COUNTIF($B$7:$B18,$B18)+ROW()/10000","v":1.0018},1.0022,"Schulze",19.001799999999999,20.001200000000001,"Wagner",2329.8500000000004]
[null,"Fischer","Ost","Stropo-2",839.87,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B19,$B19)+ROW()/10000","v":2.0019},2.0015000000000001,"",10000.001899999999,10000.001899999999,"",""]
[null,"Schneider","Nord","AA7-FX",1129.6199999999999,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B20,$B20)+ROW()/10000","v":2.0019999999999998},2.0017,"",10000.002,10000.002,"",""]
[null,"Lange","Ost","Stropo-2",1314.91,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B21,$B21)+ROW()/10000","v":1.0021},2.0019,"",10000.0021,10000.0021,{"$f":"INDEX($P$7:$P$26,MATCH(R21,$Q$7:$Q$26,0))","v":""},""]
[null,"Schulze","Süd","WWWz",896.72,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B22,$B22)+ROW()/10000","v":1.0022},2.0019999999999998,"",10000.002200000001,10000.002200000001,"",""]
[null,"Schulze","Süd","WWWz",734.88,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B23,$B23)+ROW()/10000","v":2.0023},2.0023,"",10000.0023,10000.0023,"",""]
[null,"Müller","Nord","WWWz",1367.92,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B24,$B24)+ROW()/10000","v":3.0024000000000002},2.0026000000000002,"",10000.002399999999,10000.002399999999,"",""]
[null,"Schulze","Süd","AA7-FX",887.72,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B25,$B25)+ROW()/10000","v":3.0024999999999999},3.0024000000000002,"",10000.002500000001,10000.002500000001,"",""]
[null,"Becker","Süd","AA7-FX",792.52,null,"","",null,"","",null,null,{"$f":"COUNTIF($B$7:$B26,$B26)+ROW()/10000","v":2.0026000000000002},3.0024999999999999,"",10000.0026,10000.0026,"",""]

{"sheet":"Zuf_Matrix","index":11,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion Zufallsmatrix()"]
[null,"Erzeugen einer Matrix von Zufallszahlen"]
[]
[]
[null,{"$f":"Zufallsmatrix(10,5,10,20,TRUE)","v":14},11,18,17,19,null,{"$f":"Zufallsmatrix(10,5,10,20)","v":15.830042958259583},16.453163623809814,11.360535025596619,15.683220624923706,17.455764412879944]
[null,14,19,11,13,14,null,12.29133129119873,14.200035929679871,18.60270619392395,16.883342862129211,11.950490474700928]
[null,16,14,12,16,11,null,13.896874785423279,15.989240407943726,17.792587876319885,12.516212463378906,14.819337725639343]
[null,20,20,14,20,14,null,17.862964868545532,10.748074650764465,10.419771671295166,13.298601508140564,18.35534930229187]
[null,12,11,17,15,15,null,13.980394005775452,19.094395637512207,14.659983515739441,14.615441560745239,16.667402386665344]
[null,14,18,18,13,10,null,19.131515026092529,12.754191756248474,18.21611762046814,14.715471863746643,10.937013626098633]
[null,18,13,13,15,14,null,11.988574862480164,19.060331583023071,19.040740132331848,19.887478351593018,11.858372092247009]
[null,19,17,15,14,19,null,11.787365674972534,16.350360512733459,13.986449241638184,13.977963328361511,14.679080247879028]
[null,19,10,11,11,15,null,12.423751950263977,14.020669460296631,11.612119078636169,11.066163778305054,17.893849015235901]
[null,12,20,17,18,11,null,16.216335296630859,11.707250475883484,13.23438286781311,16.528351902961731,17.395346164703369]

{"sheet":"Sequenz_1","index":12,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion Sequenz()",null,null,null,null,"Beispiel 1"]
[null,"Erzeugen von Zahlenfolgen"]
[]
[]
[null,{"$f":"Sequenz(12,5,100,25)","v":100},125,150,175,200]
[null,225,250,275,300,325]
[null,350,375,400,425,450]
[null,475,500,525,550,575]
[null,600,625,650,675,700]
[null,725,750,775,800,825]
[null,850,875,900,925,950]
[null,975,1000,1025,1050,1075]
[null,1100,1125,1150,1175,1200]
[null,1225,1250,1275,1300,1325]
[null,1350,1375,1400,1425,1450]
[null,1475,1500,1525,1550,1575]

{"sheet":"Sequenz_2","index":13,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
[null,"Funktion Sequenz()",null,null,null,"Beispiel 2"]
[null,"Termine mittwochs vierzehntäglich"]
[]
["Erster Termin im Jahr:",null,"2022-01-05",null,"Jahr:",2022]
[null,null,null,null,"Wochentag:","Mittwoch"]
[]
["Sonntag",null,{"$f":"Sequenz(27,1,$C$4,14)","v":"2022-01-05"},null,null,{"$f":"IF(YEAR(Sequenz(27,1,DATE($F$4,1,1)-MOD(DATE($F$4,1,1),7)+MOD(MATCH($F$5,$A$7:$A$13,0),7),14))=$F$4,Sequenz(27,1,DATE($F$4,1,1)-MOD(DATE($F$4,1,1),7)+MOD(MATCH($F$5,$A$7:$A$13,0),7),14),\"\")","v":"2022-01-05"}]
["Montag",null,"2022-01-19",null,null,"2022-01-19"]
["Dienstag",null,"2022-02-02",null,null,"2022-02-02"]
["Mittwoch",null,"2022-02-16",null,null,"2022-02-16"]
["Donnerstag",null,"2022-03-02",null,null,"2022-03-02"]
["Freitag",null,"2022-03-16",null,null,"2022-03-16"]
["Samstag",null,"2022-03-30",null,null,"2022-03-30"]
[null,null,"2022-04-13",null,null,"2022-04-13"]
[null,null,"2022-04-27",null,null,"2022-04-27"]
[null,null,"2022-05-11",null,null,"2022-05-11"]
[null,null,"2022-05-25",null,null,"2022-05-25"]
[null,null,"2022-06-08",null,null,"2022-06-08"]
[null,null,"2022-06-22",null,null,"2022-06-22"]
[null,null,"2022-07-06",null,null,"2022-07-06"]
[null,null,"2022-07-20",null,null,"2022-07-20"]
[null,null,"2022-08-03",null,null,"2022-08-03"]
[null,null,"2022-08-17",null,null,"2022-08-17"]
[null,null,"2022-08-31",null,null,"2022-08-31"]
[null,null,"2022-09-14",null,null,"2022-09-14"]
[null,null,"2022-09-28",null,null,"2022-09-28"]
[null,null,"2022-10-12",null,null,"2022-10-12"]
[null,null,"2022-10-26",null,null,"2022-10-26"]
[null,null,"2022-11-09",null,null,"2022-11-09"]
[null,null,"2022-11-23",null,null,"2022-11-23"]
[null,null,"2022-12-07",null,null,"2022-12-07"]
[null,null,"2022-12-21",null,null,"2022-12-21"]
[null,null,"2023-01-04",null,null,""]

{"sheet":"XVerw_1","index":14,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion XVerweis()"]
[null,"Datensatz eines Mitarbeiters nachschlagen"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","Nord","AA7-FX",2022,1656.22]
[null,"4.","Maier","Ost","BPD-4",2021,1543.42]
[null,"5.","Müller","Nord","Stropo-2",2021,1336.78]
[null,"6.","Wagner","Süd","Stropo-2",2019,1220.92]
[null,"7.","Fischer","Ost","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","Süd","WWWz",2022,1108.93]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82]
[null,"11.","Müller","Nord","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87]
[null,"14.","Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91]
[null,"16.","Schulze","Süd","WWWz",2019,896.72]
[null,"17.","Schulze","Süd","WWWz",2022,734.88]
[null,"18.","Müller","Nord","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","Süd","AA7-FX",2020,887.72]
[null,"20.","Becker","Süd","AA7-FX",2019,792.52]
[]
[]
[null,null,"Letzter Eintrag von:"]
[null,null,"Müller"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,{"$f":"XVerweis($C$28,$C$5:$C$24,$B$5:$G$24,\"Kein Treffer\",,-1)","v":"18."},"Müller","Nord","WWWz",2019,555.91999999999996]

{"sheet":"XVerw_2","index":15,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion XVerweis() und SUMME()"]
[null,"Zurückgegebene Bezüge als Argumente der SUMME-Funktion"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2018,898.27]
[null,"2.","Lehmann","West","BPD-4",2018,1508.32]
[null,"3.","Schmidt","Nord","AA7-FX",2019,1656.22]
[null,"4.","Maier","Ost","BPD-4",2019,1543.42]
[null,"5.","Müller","Nord","Stropo-2",2019,1336.78]
[null,"6.","Wagner","Süd","Stropo-2",2020,1220.92]
[null,"7.","Fischer","Ost","AA7-FX",2020,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2020,665.54]
[null,"9.","Wagner","Süd","WWWz",2020,1108.93]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82]
[null,"11.","Müller","Nord","AA7-FX",2021,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2021,699.42]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87]
[null,"14.","Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91]
[null,"16.","Schulze","Süd","WWWz",2022,896.72]
[null,"17.","Schulze","Süd","WWWz",2022,734.88]
[null,"18.","Müller","Nord","WWWz",2022,555.91999999999996]
[null,"19.","Schulze","Süd","AA7-FX",2023,887.72]
[null,"20.","Becker","Süd","AA7-FX",2023,792.52]
[]
[null,null,null,null,null,null,null,null,"Mit der Funktion"]
[null,"Die Summe der Umsätze",null,null,null,null,null,null,"SUMMEWENNS:"]
[null,"von",2020,"bis",2022,"beträgt",{"$f":"SUM(XVerweis($C$28,$F$5:$F$24,$G$5:$G$24):XVerweis($E$28,$F$5:$F$24,$G$5:$G$24,,,-1))","v":12692.649999999998},null,{"$f":"SUMIFS($G$5:$G$24,$F$5:$F$24,\">=\"&C28,$F$5:$F$24,\"<=\"&E28)","v":12692.649999999998}]
[null,null,{"$f":"XVerweis($C$28,$F$5:$F$24,$B$5:$B$24)","v":"6."},null,{"$f":"XVerweis($E$28,$F$5:$F$24,$B$5:$B$24,,,-1)","v":"18."}]

{"sheet":"XVerw_Matrix","index":16,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,8,3,8]]}
[null,"XVERWEIS() in Matrixformeln"]
[null,"Summe der Umsätze ausgewählter Mitarbeiter"]
[null,null,null,null,null,null,null,null,"Liste der ausgewählten Mitarbeiter:",null,null,null,null,null,"=XVerweis($I$5:$I$7;$C$5:$C$24;$B$5:$G$24)"]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2022,898.27,null,"Müller",null,{"$f":"XVerweis($I$5:$I$7,$C$5:$C$24,$B$5:$G$24)","v":"5."},"Müller","Nord","Stropo-2",2021,1336.78]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32,null,"Lehmann",null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","Nord","AA7-FX",2022,1656.22,null,"Baumgarten",null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"4.","Maier","Ost","BPD-4",2021,1543.42]
[null,"5.","Müller","Nord","Stropo-2",2021,1336.78]
[null,"6.","Wagner","Süd","Stropo-2",2019,1220.92]
[null,"7.","Fischer","Ost","AA7-FX",2022,1417.52,null,null,null,null,null,"=SUMME(XVerweis($I$5:$I$7;$C$5:$C$24;$G$5:$G$24;\"Kein Treffer\"))"]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","Süd","WWWz",2022,1108.93,null,null,null,"Summe der Umsätze:",null,{"$f":"SUM(XVerweis($I$5:$I$7,$C$5:$C$24,$G$5:$G$24,\"Kein Treffer\"))","v":3510.64}]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82]
[null,"11.","Müller","Nord","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87]
[null,"14.","Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91]
[null,"16.","Schulze","Süd","WWWz",2019,896.72]
[null,"17.","Schulze","Süd","WWWz",2022,734.88]
[null,"18.","Müller","Nord","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","Süd","AA7-FX",2020,887.72]
[null,"20.","Becker","Süd","AA7-FX",2019,792.52]

{"sheet":"XVerweis2_1","index":17,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion XVerweis2()"]
[null,"XVERWEIS mit mehreren Suchkriterien"]
[null,"Rückgabe der ersten gefundenen Übereinstimmung"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","Süd","AA7-FX",2022,1656.22]
[null,"4.","Maier","Ost","BPD-4",2021,1543.42]
[null,"5.","Müller","Nord","Stropo-2",2021,1336.78]
[null,"6.","Wagner","Süd","Stropo-2",2019,1220.92]
[null,"7.","Fischer","Ost","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","Süd","WWWz",2022,1108.93]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82]
[null,"11.","Müller","Nord","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87]
[null,"14.","Schneider","Süd","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91]
[null,"16.","Schulze","Süd","WWWz",2019,896.72]
[null,"17.","Schulze","Süd","WWWz",2022,734.88]
[null,"18.","Müller","Nord","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","Süd","AA7-FX",2020,887.72]
[null,"20.","Becker","Süd","AA7-FX",2019,792.52]
[]
[]
[null,null,"Mitarbeiter","Region","Produkt","Jahr"]
[null,null,"Schneider","Süd","AA7-FX"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,{"$f":"XVerweis2($C$29,$C$6:$C$25,$B$6:$G$25,\"nothing\",0,1,$D$29,$D$6:$D$25,$F$29,$F$6:$F$25,$E$29,$E$6:$E$25)","v":"14."},"Schneider","Süd","AA7-FX",2021,1129.6199999999999]

{"sheet":"XVerweis2_2","index":18,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion XVerweis2()"]
[null,"XVERWEIS mit mehreren Suchkriterien (Wildcard-Modus)",null,null,null,null,null,null,null,"Mitarbeiter","Region","Produkt","Jahr"]
[null,"Rückgabe aller gefundenen Übereinstimmungen",null,null,null,null,null,null,null,"sch*","s?d","A*"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2022,898.27,null,{"$f":"XVerweis2($J$3,$C$6:$C$25,$B$6:$G$25,\"nichts\",2,2,$K$3,$D$6:$D$25,$L$3,$E$6:$E$25,$M$3,$F$6:$F$25)","v":"3."},"Schmidt","Süd","AA7-FX",2022,1656.22]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32,null,"14.","Schneider","Süd","AA7-FX",2021,1129.6199999999999]
[null,"3.","Schmidt","Süd","AA7-FX",2022,1656.22,null,"19.","Schulze","Süd","AA7-FX",2020,887.72]
[null,"4.","Maier","Ost","BPD-4",2021,1543.42,null,"","","","","",""]
[null,"5.","Müller","Nord","Stropo-2",2021,1336.78,null,"","","","","",""]
[null,"6.","Wagner","Süd","Stropo-2",2019,1220.92,null,"","","","","",""]
[null,"7.","Fischer","Ost","AA7-FX",2022,1417.52,null,"","","","","",""]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54,null,"","","","","",""]
[null,"9.","Wagner","Süd","WWWz",2022,1108.93,null,"","","","","",""]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82,null,"","","","","",""]
[null,"11.","Müller","Nord","AA7-FX",2022,1339.58,null,"","","","","",""]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42,null,"","","","","",""]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87,null,"","","","","",""]
[null,"14.","Schneider","Süd","AA7-FX",2021,1129.6199999999999,null,"","","","","",""]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91,null,"","","","","",""]
[null,"16.","Schulze","Süd","WWWz",2019,896.72,null,"","","","","",""]
[null,"17.","Schulze","Süd","WWWz",2022,734.88,null,"","","","","",""]
[null,"18.","Müller","Nord","WWWz",2019,555.91999999999996,null,"","","","","",""]
[null,"19.","Schulze","Süd","AA7-FX",2020,887.72,null,"","","","","",""]
[null,"20.","Becker","Süd","AA7-FX",2019,792.52,null,"","","","","",""]

{"sheet":"XVergleich","index":19,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Funktion XVergleich()"]
[null,"Die relative Position des Suchbegriffs in einer Liste finden"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","Süd","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","Nord","AA7-FX",2022,1656.22]
[null,"4.","Maier","Ost","BPD-4",2021,1543.42]
[null,"5.","Müller","Nord","Stropo-2",2021,1336.78]
[null,"6.","Wagner","Süd","Stropo-2",2019,1220.92]
[null,"7.","Fischer","Ost","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","Süd","WWWz",2022,1108.93]
[null,"10.","Schneider","Nord","BPD-4",2020,768.82]
[null,"11.","Müller","Nord","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","Ost","Stropo-2",2021,839.87]
[null,"14.","Schneider","Nord","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","Ost","Stropo-2",2021,1314.91]
[null,"16.","Schulze","Süd","WWWz",2019,896.72]
[null,"17.","Schulze","Süd","WWWz",2022,734.88]
[null,"18.","Müller","Nord","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","Süd","AA7-FX",2020,887.72]
[null,"20.","Becker","Süd","AA7-FX",2019,792.52]
[]
[]
[null,null,"Der erste Eintrag des Mitarbeiters"]
[null,null,"Müller"]
[null,null,"ist an Position"]
[null,null,{"$f":"XVergleich($C$28,$C$5:$C$24)","v":5}]