{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Sort_1","Sortby","Sort_2","Struct_Ref","Sortby2_1","Sortby2_2","Birth_List","Filter","Unique","Uniq_Filt_Sort","Example Sales","Rand_Array","Sequenz_1","Sequence_2","XLookup_1","XLookup_2","XLookup_Arr_formulas","XLookup2_1","Sheet17","XLookup2_2","XMatch"],"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":"Sort_1","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,10,0,11],[4,13,6,18],[7,13,9,18],[10,13,12,13],[10,14,12,18],[0,14,0,18],[13,13,16,13],[13,14,16,18],[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]]}
[null,"Function Sort_()",null,null,null,null,null,null,null,null,"Version 3.8\nLast update:\n24.10.2024",null,null,"Available functions:","Filter_, Randarray, Sequence, Sort_, Sortby, Sortby2, Unique, XLookup, XLookup2, XMatch"]
[null,"Sort by 1 column (1 sorting criterion)"]
[]
[null,"Data",null,null,null,null,null,"Sorted list"]
[null,"Employee","Region","Product","Year","Sales",null,{"$f":"$B$5","v":"Employee"},{"$f":"$C$5","v":"Region"},{"$f":"$D$5","v":"Product"},{"$f":"$E$5","v":"Year"},{"$f":"$F$5","v":"Sales"},null,"Syntax"]
[null,"Becker","South","WWWz",2022,898.27,null,{"$f":"Sort_($B$6:$F$25,5,-1)","v":"Schmidt"},"North","AA7-FX",2022,1656.22]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Maier","East","BPD-4",2021,1543.42]
[null,"Schmidt","North","AA7-FX",2022,1656.22,null,"Lehmann","West","BPD-4",2021,1508.32,null,"= Sort_ ( array, [sort_index], [sort_order], [by_column] )"]
[null,"Maier","East","BPD-4",2021,1543.42,null,"Fischer","East","AA7-FX",2022,1417.52]
[null,"Müller","North","Stropo-2",2021,1336.78,null,"Müller","North","WWWz",2019,1367.92]
[null,"Wagner","South","Stropo-2",2019,1220.92,null,"Müller","North","AA7-FX",2022,1339.58,null,"array","The range or array to Sort_"]
[null,"Fischer","East","AA7-FX",2022,1417.52,null,"Müller","North","Stropo-2",2021,1336.78]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,"Lange","East","Stropo-2",2021,1314.91]
[null,"Wagner","South","WWWz",2022,1108.93,null,"Wagner","South","Stropo-2",2019,1220.92,null,"sort_index\n(optional)","A number indicating the row or column to Sort_ by\n(default: number = 1)"]
[null,"Schneider","North","BPD-4",2020,768.82,null,"Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"Müller","North","AA7-FX",2022,1339.58,null,"Wagner","South","WWWz",2022,1108.93]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Becker","South","WWWz",2022,898.27]
[null,"Fischer","East","Stropo-2",2021,839.87,null,"Schulze","South","WWWz",2019,896.72,null,"sort_order\n(optional)","Sort order:\n 1  for ascending (default)\n-1  for descending"]
[null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,"Schulze","South","AA7-FX",2020,887.72]
[null,"Lange","East","Stropo-2",2021,1314.91,null,"Fischer","East","Stropo-2",2021,839.87]
[null,"Schulze","South","WWWz",2019,896.72,null,"Becker","South","AA7-FX",2019,792.52]
[null,"Schulze","South","WWWz",2022,734.88,null,"Schneider","North","BPD-4",2020,768.82,null,"by_column\n(optional)","A logical value indicating the desired Sort_ direction\nFALSE  for vertical Sort_ing by row (default)\nTRUE  for horizontal Sort_ing by column"]
[null,"Müller","North","WWWz",2019,1367.92,null,"Schulze","South","WWWz",2022,734.88]
[null,"Schulze","South","AA7-FX",2020,887.72,null,"Schäfer","West","Stropo-2",2019,699.42]
[null,"Becker","South","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,"The syntax is the same as for the SORT function for Excel 365."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"See also:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"https://support.microsoft.com/en-us/office/Sort_-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c"]

{"sheet":"Sortby","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,"Function Sortby()",null,null,null,null,null,"Sorted by"]
[null,"Sort by 3 columns (3 sorting criteria)",null,null,null,null,null,"1.  year (descending)"]
[null,null,null,null,null,null,null,"2.  product (ascending)"]
[null,"Data",null,null,null,null,null,"3.  emplyees (ascending)"]
[null,"Employee","Region","Product","Year","Sales",null,{"$f":"$B$5","v":"Employee"},{"$f":"$C$5","v":"Region"},{"$f":"$D$5","v":"Product"},{"$f":"$E$5","v":"Year"},{"$f":"$F$5","v":"Sales"},null,"Syntax"]
[null,"Becker","South","WWWz",2022,898.27,null,{"$f":"Sortby($B$6:$F$29,$E$6:$E$29,-1,$D$6:$D$29,1,$B$6:$B$29)","v":"Fischer"},"East","AA7-FX",2022,1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Müller","North","AA7-FX",2022,1339.58]
[null,"Schmidt","North","AA7-FX",2022,1656.22,null,"Schmidt","North","AA7-FX",2022,1656.22,null,"= Sortby ( array, [by_array1], [sort_order1], [by_array2], [sort_order2], … )"]
[null,"Maier","East","BPD-4",2021,1543.42,null,"Becker","South","WWWz",2022,898.27]
[null,"Müller","North","Stropo-2",2021,1336.78,null,"Schulze","South","WWWz",2022,734.88]
[null,"Wagner","South","Stropo-2",2019,1220.92,null,"Wagner","South","WWWz",2022,1108.93,null,"array","The range or array to sort"]
[null,"Fischer","East","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","South","WWWz",2022,1108.93,null,"Schneider","North","XLT-1",2022,1446.6,null,"by_array1","The range or array to sort on"]
[null,"Schneider","North","BPD-4",2020,768.82,null,"Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"Müller","North","AA7-FX",2022,1339.58,null,"Lehmann","West","BPD-4",2021,1508.32]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Maier","East","BPD-4",2021,1543.42]
[null,"Fischer","East","Stropo-2",2021,839.87,null,"Fischer","East","Stropo-2",2021,839.87,null,"sort_order1\n(optional)","Sort order:\n 1  for ascending (default)\n-1  for descending"]
[null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,"Lange","East","Stropo-2",2021,1314.91]
[null,"Lange","East","Stropo-2",2021,1314.91,null,"Müller","North","Stropo-2",2021,1336.78]
[null,"Schulze","South","WWWz",2019,896.72,null,"Schmidt","North","WWWz",2021,1014]
[null,"Schulze","South","WWWz",2022,734.88,null,"Schneider","North","WWWz",2021,1083.9000000000001,null,"by_array2\n(optional)","The range or array to sort on"]
[null,"Müller","North","WWWz",2019,1367.92,null,"Schulze","South","AA7-FX",2020,887.72]
[null,"Schulze","South","AA7-FX",2020,887.72,null,"Schneider","North","BPD-4",2020,768.82]
[null,"Becker","South","AA7-FX",2019,792.52,null,"Becker","South","AA7-FX",2019,792.52]
[null,"Schmidt","North","WWWz",2021,1014,null,"Schäfer","West","Stropo-2",2019,699.42,null,"sort_order2\n(optional)","Sort order:\n 1  for ascending (default)\n-1  for descending"]
[null,"Schneider","North","XLT-1",2022,1446.6,null,"Wagner","South","Stropo-2",2019,1220.92]
[null,"Lehmann","West","XLT-1",2022,926.99,null,"Müller","North","WWWz",2019,1367.92]
[null,"Schneider","North","WWWz",2021,1083.9000000000001,null,"Schulze","South","WWWz",2019,896.72]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The syntax is the same as for the SORTBY function for Excel 365."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"See also:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"https://support.microsoft.com/en-us/office/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f"]

{"sheet":"Sort_2","index":2,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Function Sort_()"]
[null,"Sort by multiple columns (multiple sorting criteria)",null,null,null,null,null,null,null,null,null,null,null,4,2,1]
[]
[null,"Data",null,null,null,null,null,"Sorted by Year und Sales",null,null,null,null,null,"Sorted by Year, Region and Employee"]
[null,"Employee","Region","Product","Year","Sales",null,"Employee","Region","Product","Year","Sales",null,"Employee","Region","Product","Year","Sales"]
[null,"Becker","South","WWWz",2022,898.27,null,{"$f":"Sort_($B$6:$F$25,{4;5},{-1;1})","v":"Baumgarten"},"West","XLT-1",2022,665.54,null,{"$f":"Sort_($B$6:$F$25,$N$2:$P$2,{-1;1;1})","v":"Fischer"},"East","AA7-FX",2022,1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,"Schulze","South","WWWz",2022,734.88,null,"Müller","North","AA7-FX",2022,1339.58]
[null,"Schmidt","North","AA7-FX",2022,1656.22,null,"Becker","South","WWWz",2022,898.27,null,"Schmidt","North","AA7-FX",2022,1656.22]
[null,"Maier","East","BPD-4",2021,1543.42,null,"Wagner","South","WWWz",2022,1108.93,null,"Becker","South","WWWz",2022,898.27]
[null,"Müller","North","Stropo-2",2021,1336.78,null,"Müller","North","AA7-FX",2022,1339.58,null,"Schulze","South","WWWz",2022,734.88]
[null,"Wagner","South","Stropo-2",2019,1220.92,null,"Fischer","East","AA7-FX",2022,1417.52,null,"Wagner","South","WWWz",2022,1108.93]
[null,"Fischer","East","AA7-FX",2022,1417.52,null,"Schmidt","North","AA7-FX",2022,1656.22,null,"Baumgarten","West","XLT-1",2022,665.54]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,"Fischer","East","Stropo-2",2021,839.87,null,"Fischer","East","Stropo-2",2021,839.87]
[null,"Wagner","South","WWWz",2022,1108.93,null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,"Lange","East","Stropo-2",2021,1314.91]
[null,"Schneider","North","BPD-4",2020,768.82,null,"Lange","East","Stropo-2",2021,1314.91,null,"Maier","East","BPD-4",2021,1543.42]
[null,"Müller","North","AA7-FX",2022,1339.58,null,"Müller","North","Stropo-2",2021,1336.78,null,"Müller","North","Stropo-2",2021,1336.78]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,"Lehmann","West","BPD-4",2021,1508.32,null,"Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"Fischer","East","Stropo-2",2021,839.87,null,"Maier","East","BPD-4",2021,1543.42,null,"Lehmann","West","BPD-4",2021,1508.32]
[null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,"Schneider","North","BPD-4",2020,768.82,null,"Schneider","North","BPD-4",2020,768.82]
[null,"Lange","East","Stropo-2",2021,1314.91,null,"Schulze","South","AA7-FX",2020,887.72,null,"Schulze","South","AA7-FX",2020,887.72]
[null,"Schulze","South","WWWz",2019,896.72,null,"Schäfer","West","Stropo-2",2019,699.42,null,"Müller","North","WWWz",2019,1367.92]
[null,"Schulze","South","WWWz",2022,734.88,null,"Becker","South","AA7-FX",2019,792.52,null,"Becker","South","AA7-FX",2019,792.52]
[null,"Müller","North","WWWz",2019,1367.92,null,"Schulze","South","WWWz",2019,896.72,null,"Schulze","South","WWWz",2019,896.72]
[null,"Schulze","South","AA7-FX",2020,887.72,null,"Wagner","South","Stropo-2",2019,1220.92,null,"Wagner","South","Stropo-2",2019,1220.92]
[null,"Becker","South","AA7-FX",2019,792.52,null,"Müller","North","WWWz",2019,1367.92,null,"Schäfer","West","Stropo-2",2019,699.42]

{"sheet":"Struct_Ref","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,5]]}
[null,"Use of structured references"]
[]
[]
[null,"Number","Amount",null,{"$f":"Fond[[#Headers],[Number]]","v":"Number"},{"$f":"Fond[[#Headers],[Amount]]","v":"Amount"}]
[null,5,100,null,{"$f":"Sort_(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":"Sortby2_1","index":4,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Function Sortby2()",null,null,null,null,null,"Sorted by"]
[null,"Sort by 3 columns (3 sorting criteria)",null,null,null,null,null,"1.  year (descending)"]
[null,null,null,null,null,null,null,"2.  product (ascending)"]
[null,"Data",null,null,null,null,null,"3.  emplyees (ascending)"]
[null,"Employee","Region","Product","Year","Sales",null,"Year","Product","Employee","Region",{"$f":"$F$5","v":"Sales"}]
[null,"Becker","South","WWWz",2022,898.27,null,{"$f":"Sortby2($B$6:$F$29,$E$6:$E$29,-1,$D$6:$D$29,1,$B$6:$B$29)","v":2022},"AA7-FX","Fischer","East",1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,2022,"AA7-FX","Müller","North",1339.58]
[null,"Schmidt","North","AA7-FX",2022,1656.22,null,2022,"AA7-FX","Schmidt","North",1656.22]
[null,"Maier","East","BPD-4",2021,1543.42,null,2022,"WWWz","Becker","South",898.27]
[null,"Müller","North","Stropo-2",2021,1336.78,null,2022,"WWWz","Schulze","South",734.88]
[null,"Wagner","South","Stropo-2",2019,1220.92,null,2022,"WWWz","Wagner","South",1108.93]
[null,"Fischer","East","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","South","WWWz",2022,1108.93,null,2022,"XLT-1","Schneider","North",1446.6]
[null,"Schneider","North","BPD-4",2020,768.82,null,2021,"AA7-FX","Schneider","North",1129.6199999999999]
[null,"Müller","North","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","East",1543.42]
[null,"Fischer","East","Stropo-2",2021,839.87,null,2021,"Stropo-2","Fischer","East",839.87]
[null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,2021,"Stropo-2","Lange","East",1314.91]
[null,"Lange","East","Stropo-2",2021,1314.91,null,2021,"Stropo-2","Müller","North",1336.78]
[null,"Schulze","South","WWWz",2019,896.72,null,2021,"WWWz","Schmidt","North",1014]
[null,"Schulze","South","WWWz",2022,734.88,null,2021,"WWWz","Schneider","North",1083.9000000000001]
[null,"Müller","North","WWWz",2019,1367.92,null,2020,"AA7-FX","Schulze","South",887.72]
[null,"Schulze","South","AA7-FX",2020,887.72,null,2020,"BPD-4","Schneider","North",768.82]
[null,"Becker","South","AA7-FX",2019,792.52,null,2019,"AA7-FX","Becker","South",792.52]
[null,"Schmidt","North","WWWz",2021,1014,null,2019,"Stropo-2","Schäfer","West",699.42]
[null,"Schneider","North","XLT-1",2022,1446.6,null,2019,"Stropo-2","Wagner","South",1220.92]
[null,"Lehmann","West","XLT-1",2022,926.99,null,2019,"WWWz","Müller","North",1367.92]
[null,"Schneider","North","WWWz",2021,1083.9000000000001,null,2019,"WWWz","Schulze","South",896.72]

{"sheet":"Sortby2_2","index":5,"n_rows":105,"n_cols":13,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Function Sortby2()",null,null,null,null,null,null,"sorting\ncriterion\n1","sorting\ncriterion\n2","sorting\ncriterion\n3","sorting\ncriterion\n4","sorting\ncriterion\n5"]
[null,"Sort by 5 columns (5 sorting criteria)",null,null,null,null,null,"Sort by:","Year","Region","Product","Employee","Sales"]
[null,"with free choice",null,null,null,null,null,null,"descending","ascending","ascending","ascending","descending"]
[]
[null,"Employee","Region","Product","Year","Sales",null,null,{"$f":"$I$2","v":"Year"},{"$f":"$J$2","v":"Region"},{"$f":"$K$2","v":"Product"},{"$f":"$L$2","v":"Employee"},{"$f":"$M$2","v":"Sales"}]
[null,"Becker","South","WWWz",2022,898.27,null,null,{"$f":"Sortby2($B$6:$F$105,OFFSET($B$6,0,MATCH($I$2,$B$5:$F$5,0)-1,100,1),IF($I$3=\"descending\",-1,1),OFFSET($B$6,0,MATCH($J$2,$B$5:$F$5,0)-1,100,1),IF($J$3=\"descending\",-1,1),OFFSET($B$6,0,MATCH($K$2,$B$5:$F$5,0)-1,100,1),IF($K$3=\"descending\",-1,1),OFFSET($B$6,0,MATCH($L$2,$B$5:$F$5,0)-1,100,1),IF($L$3=\"descending\",-1,1),OFFSET($B$6,0,MATCH($M$2,$B$5:$F$5,0)-1,100,1),IF($M$3=\"descending\",-1,1))","v":2022},"East","AA7-FX","Fischer",1417.52]
[null,"Lehmann","West","BPD-4",2021,1508.32,null,null,2022,"East","XLT-1","Fischer",793.99]
[null,"Schmidt","North","AA7-FX",2022,1656.22,null,null,2022,"East","XLT-1","Lange",955.55]
[null,"Maier","East","BPD-4",2021,1543.42,null,null,2022,"East","XLT-1","Maier",1637.66]
[null,"Müller","North","Stropo-2",2021,1336.78,null,null,2022,"North","AA7-FX","Müller",1339.58]
[null,"Wagner","South","Stropo-2",2019,1220.92,null,null,2022,"North","AA7-FX","Schmidt",1656.22]
[null,"Fischer","East","AA7-FX",2022,1417.52,null,null,2022,"North","AA7-FX","Schneider",925.51]
[null,"Baumgarten","West","XLT-1",2022,665.54,null,null,2022,"North","XLT-1","Müller",1868.11]
[null,"Wagner","South","WWWz",2022,1108.93,null,null,2022,"North","XLT-1","Schmidt",1165.8399999999999]
[null,"Schneider","North","BPD-4",2020,768.82,null,null,2022,"North","XLT-1","Schneider",1446.6]
[null,"Müller","North","AA7-FX",2022,1339.58,null,null,2022,"South","WWWz","Becker",898.27]
[null,"Schäfer","West","Stropo-2",2019,699.42,null,null,2022,"South","WWWz","Schulze",734.88]
[null,"Fischer","East","Stropo-2",2021,839.87,null,null,2022,"South","WWWz","Wagner",1108.93]
[null,"Schneider","North","AA7-FX",2021,1129.6199999999999,null,null,2022,"South","XLT-1","Becker",1244.43]
[null,"Lange","East","Stropo-2",2021,1314.91,null,null,2022,"South","XLT-1","Schulze",1084.07]
[null,"Schulze","South","WWWz",2019,896.72,null,null,2022,"South","XLT-1","Wagner",1097.5999999999999]
[null,"Schulze","South","WWWz",2022,734.88,null,null,2022,"West","WWWz","Baumgarten",848.1]
[null,"Müller","North","WWWz",2019,1367.92,null,null,2022,"West","WWWz","Lehmann",562.45000000000005]
[null,"Schulze","South","AA7-FX",2020,887.72,null,null,2022,"West","WWWz","Schäfer",1016.32]
[null,"Becker","South","AA7-FX",2019,792.52,null,null,2022,"West","XLT-1","Baumgarten",665.54]
[null,"Schmidt","North","WWWz",2021,1014,null,null,2022,"West","XLT-1","Lehmann",926.99]
[null,"Schneider","North","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,"East","BPD-4","Fischer",1019.52]
[null,"Schneider","North","WWWz",2021,1083.9000000000001,null,null,2021,"East","BPD-4","Lange",921.62]
[null,"Becker","South","XLT-1",2020,1305.32,null,null,2021,"East","BPD-4","Maier",1543.42]
[null,"Schäfer","West","BPD-4",2021,696.92,null,null,2021,"East","Stropo-2","Fischer",839.87]
[null,"Müller","North","BPD-4",2021,1185.42,null,null,2021,"East","Stropo-2","Lange",1314.91]
[null,"Schmidt","North","WWWz",2019,907.42,null,null,2021,"East","Stropo-2","Maier",1046.92]
[null,"Maier","East","XLT-1",2020,1549.92,null,null,2021,"East","WWWz","Fischer",993.58]
[null,"Schneider","North","AA7-FX",2022,925.51,null,null,2021,"East","WWWz","Lange",828.17]
[null,"Maier","East","WWWz",2021,1082.8399999999999,null,null,2021,"East","WWWz","Maier",1082.8399999999999]
[null,"Lehmann","West","Stropo-2",2019,1577.22,null,null,2021,"North","AA7-FX","Schneider",1129.6199999999999]
[null,"Lange","East","WWWz",2021,828.17,null,null,2021,"North","BPD-4","Müller",1185.42]
[null,"Maier","East","XLT-1",2022,1637.66,null,null,2021,"North","BPD-4","Schmidt",1280.02]
[null,"Baumgarten","West","WWWz",2022,848.1,null,null,2021,"North","Stropo-2","Müller",1336.78]
[null,"Schulze","South","XLT-1",2022,1084.07,null,null,2021,"North","Stropo-2","Schmidt",1323.24]
[null,"Baumgarten","West","AA7-FX",2020,989.92,null,null,2021,"North","Stropo-2","Schneider",636.59]
[null,"Baumgarten","West","BPD-4",2021,1462.42,null,null,2021,"North","WWWz","Müller",1624]
[null,"Schneider","North","XLT-1",2020,1581.02,null,null,2021,"North","WWWz","Schmidt",1014]
[null,"Schulze","South","XLT-1",2020,1136.52,null,null,2021,"North","WWWz","Schneider",1083.9000000000001]
[null,"Schulze","South","Stropo-2",2019,831.72,null,null,2021,"South","BPD-4","Becker",980.52]
[null,"Lehmann","West","Stropo-2",2021,1890.05,null,null,2021,"South","BPD-4","Schulze",667.42]
[null,"Fischer","East","AA7-FX",2020,1275.02,null,null,2021,"South","BPD-4","Wagner",661.92]
[null,"Becker","South","BPD-4",2021,980.52,null,null,2021,"South","Stropo-2","Becker",859.6]
[null,"Lange","East","WWWz",2019,684.82,null,null,2021,"South","Stropo-2","Schulze",809.39]
[null,"Lange","East","Stropo-2",2019,1498.32,null,null,2021,"South","Stropo-2","Wagner",1288.92]
[null,"Schmidt","North","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","North","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","East","XLT-1",2020,712.72,null,null,2021,"West","Stropo-2","Lehmann",1890.05]
[null,"Müller","North","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,"East","AA7-FX","Fischer",1275.02]
[null,"Schäfer","West","AA7-FX",2020,1418.42,null,null,2020,"East","AA7-FX","Lange",878.82]
[null,"Maier","East","Stropo-2",2019,992.62,null,null,2020,"East","AA7-FX","Maier",1496.82]
[null,"Fischer","East","Stropo-2",2019,1005.02,null,null,2020,"East","XLT-1","Fischer",712.72]
[null,"Lehmann","West","WWWz",2022,562.45000000000005,null,null,2020,"East","XLT-1","Lange",906.42]
[null,"Becker","South","Stropo-2",2019,1103.42,null,null,2020,"East","XLT-1","Maier",1549.92]
[null,"Schneider","North","Stropo-2",2021,636.59,null,null,2020,"North","AA7-FX","Müller",1510.32]
[null,"Maier","East","WWWz",2019,1347.42,null,null,2020,"North","AA7-FX","Schmidt",1540.02]
[null,"Wagner","South","XLT-1",2022,1097.5999999999999,null,null,2020,"North","BPD-4","Schneider",768.82]
[null,"Schäfer","West","Stropo-2",2021,748.37,null,null,2020,"North","XLT-1","Müller",1583.82]
[null,"Wagner","South","Stropo-2",2021,1288.92,null,null,2020,"North","XLT-1","Schmidt",1033.42]
[null,"Lehmann","West","AA7-FX",2020,990.52,null,null,2020,"North","XLT-1","Schneider",1581.02]
[null,"Wagner","South","BPD-4",2021,661.92,null,null,2020,"South","AA7-FX","Becker",991.12]
[null,"Müller","North","AA7-FX",2020,1510.32,null,null,2020,"South","AA7-FX","Schulze",887.72]
[null,"Fischer","East","BPD-4",2021,1019.52,null,null,2020,"South","AA7-FX","Wagner",1029.82]
[null,"Fischer","East","WWWz",2019,975.82,null,null,2020,"South","XLT-1","Becker",1305.32]
[null,"Lange","East","AA7-FX",2020,878.82,null,null,2020,"South","XLT-1","Schulze",1136.52]
[null,"Lange","East","XLT-1",2020,906.42,null,null,2020,"South","XLT-1","Wagner",943.52]
[null,"Wagner","South","XLT-1",2020,943.52,null,null,2020,"West","AA7-FX","Baumgarten",989.92]
[null,"Müller","North","WWWz",2021,1624,null,null,2020,"West","AA7-FX","Lehmann",990.52]
[null,"Becker","South","Stropo-2",2021,859.6,null,null,2020,"West","AA7-FX","Schäfer",1418.42]
[null,"Fischer","East","XLT-1",2022,793.99,null,null,2020,"West","WWWz","Baumgarten",982.32]
[null,"Schneider","North","WWWz",2019,924.82,null,null,2020,"West","XLT-1","Baumgarten",659.82]
[null,"Müller","North","XLT-1",2022,1868.11,null,null,2020,"West","XLT-1","Lehmann",1206.82]
[null,"Fischer","East","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,"East","Stropo-2","Fischer",1005.02]
[null,"Maier","East","Stropo-2",2021,1046.92,null,null,2019,"East","Stropo-2","Lange",1498.32]
[null,"Wagner","South","WWWz",2019,1140.52,null,null,2019,"East","Stropo-2","Maier",992.62]
[null,"Baumgarten","West","WWWz",2020,982.32,null,null,2019,"East","WWWz","Fischer",975.82]
[null,"Becker","South","XLT-1",2022,1244.43,null,null,2019,"East","WWWz","Lange",684.82]
[null,"Lehmann","West","XLT-1",2020,1206.82,null,null,2019,"East","WWWz","Maier",1347.42]
[null,"Schäfer","West","XLT-1",2020,1562.62,null,null,2019,"North","Stropo-2","Müller",1445.42]
[null,"Lange","East","XLT-1",2022,955.55,null,null,2019,"North","Stropo-2","Schmidt",1275.72]
[null,"Schneider","North","Stropo-2",2019,850.12,null,null,2019,"North","Stropo-2","Schneider",850.12]
[null,"Maier","East","AA7-FX",2020,1496.82,null,null,2019,"North","WWWz","Müller",1367.92]
[null,"Schulze","South","BPD-4",2021,667.42,null,null,2019,"North","WWWz","Schmidt",907.42]
[null,"Schmidt","North","BPD-4",2021,1280.02,null,null,2019,"North","WWWz","Schneider",924.82]
[null,"Baumgarten","West","Stropo-2",2019,1022.82,null,null,2019,"South","AA7-FX","Becker",792.52]
[null,"Wagner","South","AA7-FX",2020,1029.82,null,null,2019,"South","Stropo-2","Becker",1103.42]
[null,"Baumgarten","West","XLT-1",2020,659.82,null,null,2019,"South","Stropo-2","Schulze",831.72]
[null,"Müller","North","XLT-1",2020,1583.82,null,null,2019,"South","Stropo-2","Wagner",1220.92]
[null,"Becker","South","AA7-FX",2020,991.12,null,null,2019,"South","WWWz","Schulze",896.72]
[null,"Schulze","South","Stropo-2",2021,809.39,null,null,2019,"South","WWWz","Wagner",1140.52]
[null,"Lange","East","BPD-4",2021,921.62,null,null,2019,"West","Stropo-2","Baumgarten",1022.82]
[null,"Schmidt","North","Stropo-2",2019,1275.72,null,null,2019,"West","Stropo-2","Lehmann",1577.22]
[null,"Schmidt","North","Stropo-2",2021,1323.24,null,null,2019,"West","Stropo-2","Schäfer",699.42]
[null,"Schmidt","North","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":"Birth_List","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Birthday list"]
[]
[null,"Name","Birth date",null,"Birthday","Name"]
[null,"Wagner","1950-06-14",null,{"$f":"Sort_(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":[]}
[null,"Function Filter_()",null,null,null,null,"Ex. 1",null,null,null,null,"Ex. 2",null,null,null,null,"Ex. 3",null,null,null,null,"Ex. 4"]
[null,"Filtering of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter twice (nested):"]
[null,null,null,null,null,null,"Horizontal filtering:",null,null,null,null,"Vertical filtering:",null,null,null,null,"combination with Sort_:",null,null,null,null,"1.  by column headings (horizontal)"]
[null,"Data",null,null,null,null,"filtered by column headings",null,null,null,null,"Only sales between 1000 and 1500",null,null,null,null,"Like the last table, but also Sort_ed by sale",null,null,null,null,"2.  by sale > 1000  (vertical)"]
[null,"Employee","Region","Product","Sales",null,{"$f":"Filter_(B5:E25,(B5:E5=\"Region\")+(B5:E5=\"Sales\"))","v":"Region"},"Sales","","",null,"Employee","Region","Product","Sales",null,"Employee","Region","Product","Sales",null,{"$f":"Filter_(Filter_(B5:E25,(B5:E5=\"Region\")+(B5:E5=\"Sales\")),E5:E25>1000)","v":"Region"},"Sales","",""]
[null,"Becker","South","WWWz",898.27,null,"South",898.27,"","",null,{"$f":"Filter_(B6:E25,(E6:E25>1000)*(E6:E25<1500),\"no data\")","v":"Müller"},"North","Stropo-2",1336.78,null,{"$f":"Sort_(Filter_(B6:E25,(E6:E25>1000)*(E6:E25<1500)),4,-1)","v":"Fischer"},"East","AA7-FX",1417.52,null,"West",1508.32,"",""]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",1508.32,"","",null,"Wagner","South","Stropo-2",1220.92,null,"Müller","North","WWWz",1367.92,null,"North",1656.22,"",""]
[null,"Schmidt","North","AA7-FX",1656.22,null,"North",1656.22,"","",null,"Fischer","East","AA7-FX",1417.52,null,"Müller","North","AA7-FX",1339.58,null,"East",1543.42,"",""]
[null,"Maier","East","BPD-4",1543.42,null,"East",1543.42,"","",null,"Wagner","South","WWWz",1108.93,null,"Müller","North","Stropo-2",1336.78,null,"North",1336.78,"",""]
[null,"Müller","North","Stropo-2",1336.78,null,"North",1336.78,"","",null,"Müller","North","AA7-FX",1339.58,null,"Lange","East","Stropo-2",1314.91,null,"South",1220.92,"",""]
[null,"Wagner","South","Stropo-2",1220.92,null,"South",1220.92,"","",null,"Schneider","North","AA7-FX",1129.6199999999999,null,"Wagner","South","Stropo-2",1220.92,null,"East",1417.52,"",""]
[null,"Fischer","East","AA7-FX",1417.52,null,"East",1417.52,"","",null,"Lange","East","Stropo-2",1314.91,null,"Schneider","North","AA7-FX",1129.6199999999999,null,"South",1108.93,"",""]
[null,"Baumgarten","West","XLT-1",665.54,null,"West",665.54,"","",null,"Müller","North","WWWz",1367.92,null,"Wagner","South","WWWz",1108.93,null,"North",1339.58,"",""]
[null,"Wagner","South","WWWz",1108.93,null,"South",1108.93,"","",null,"","","","",null,"","","","",null,"North",1129.6199999999999,"",""]
[null,"Schneider","North","BPD-4",768.82,null,"North",768.82,"","",null,"","","","",null,"","","","",null,"East",1314.91,"",""]
[null,"Müller","North","AA7-FX",1339.58,null,"North",1339.58,"","",null,"","","","",null,"","","","",null,"North",1367.92,"",""]
[null,"Schäfer","West","Stropo-2",699.42,null,"West",699.42,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Fischer","East","Stropo-2",839.87,null,"East",839.87,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schneider","North","AA7-FX",1129.6199999999999,null,"North",1129.6199999999999,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Lange","East","Stropo-2",1314.91,null,"East",1314.91,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","South","WWWz",896.72,null,"South",896.72,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","South","WWWz",734.88,null,"South",734.88,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Müller","North","WWWz",1367.92,null,"North",1367.92,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Schulze","South","AA7-FX",887.72,null,"South",887.72,"","",null,"","","","",null,"","","","",null,"","","",""]
[null,"Becker","South","AA7-FX",792.52,null,"South",792.52,"","",null,"","","","",null,"","","","",null,"","","",""]

{"sheet":"Unique","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,"Function Unique()"]
[null,"UNIQUE function (list duplicates only once",null,null,null,null,null,null,"What products are there?\n (Sort_iert)",null,"Which employees appear only once?"]
[null,"or select unique ones)",null,null,null,null,"What regions are there?",null,null,null,null,null,"What combinations of employees and regions are there?"]
[]
[null,"Data"]
[null,"Employee","Region","Product","Sales",null,"Regions",null,"Products",null,"Employees",null,"Employee","Region"]
[null,"Becker","South","WWWz",898.27,null,{"$f":"Unique($C$7:$C$26)","v":"South"},null,{"$f":"Sort_(Unique($D$7:$D$26))","v":"AA7-FX"},null,{"$f":"Unique($B$7:$B$26,,TRUE)","v":"Lehmann"},null,{"$f":"Unique($B$7:$C$26)","v":"Becker"},"South"]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",null,"BPD-4",null,"Schmidt",null,"Lehmann","West"]
[null,"Schmidt","North","AA7-FX",1656.22,null,"North",null,"Stropo-2",null,"Maier",null,"Schmidt","North"]
[null,"Maier","East","BPD-4",1543.42,null,"East",null,"WWWz",null,"Baumgarten",null,"Maier","East"]
[null,"Müller","North","Stropo-2",1336.78,null,"",null,"XLT-1",null,"Schäfer",null,"Müller","North"]
[null,"Wagner","South","Stropo-2",1220.92,null,"",null,"",null,"Lange",null,"Wagner","South"]
[null,"Fischer","East","AA7-FX",1417.52,null,"",null,"",null,"",null,"Fischer","East"]
[null,"Baumgarten","West","XLT-1",665.54,null,"",null,"",null,"",null,"Baumgarten","West"]
[null,"Wagner","South","WWWz",1108.93,null,"",null,"",null,"",null,"Schneider","North"]
[null,"Schneider","North","BPD-4",768.82,null,"",null,"",null,"",null,"Schäfer","West"]
[null,"Müller","North","AA7-FX",1339.58,null,"",null,"",null,"",null,"Lange","East"]
[null,"Schäfer","West","Stropo-2",699.42,null,"",null,"",null,"",null,"Schulze","South"]
[null,"Fischer","East","Stropo-2",839.87,null,"",null,"",null,"",null,"",""]
[null,"Schneider","North","AA7-FX",1129.6199999999999,null,"",null,"",null,"",null,"",""]
[null,"Lange","East","Stropo-2",1314.91,null,"",null,"",null,"",null,"",""]
[null,"Schulze","South","WWWz",896.72,null,"",null,"",null,"",null,"",""]
[null,"Schulze","South","WWWz",734.88,null,"",null,"",null,"",null,"",""]
[null,"Müller","North","WWWz",1367.92,null,"",null,"",null,"",null,"",""]
[null,"Schulze","South","AA7-FX",887.72,null,"",null,"",null,"",null,"",""]
[null,"Becker","South","AA7-FX",792.52,null,"",null,"",null,"",null,"",""]

{"sheet":"Uniq_Filt_Sort","index":9,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,6,4,6],[1,1,2,5]]}
[null,"Combination of Unique, Filter_, Sort_"]
[null,"and structured references"]
[null,null,null,null,null,null,"What regions are there?",null,"employees of"]
[null,null,null,null,null,null,null,null,"South"]
[null,"Data",null,null,null,null,null,null,"region"]
[null,"Employee","Region","Product","Sales",null,"Region",null,"Employee"]
[null,"Becker","South","WWWz",898.27,null,{"$f":"Unique(Data[Region])","v":"South"},null,{"$f":"Sort_(Unique(Filter_(Data[Employee],Data[Region]=$I$4)))","v":"Becker"}]
[null,"Lehmann","West","BPD-4",1508.32,null,"West",null,"Schulze"]
[null,"Schmidt","North","AA7-FX",1656.22,null,"North",null,"Wagner"]
[null,"Maier","East","BPD-4",1543.42,null,"East",null,""]
[null,"Müller","North","Stropo-2",1336.78,null,"",null,""]
[null,"Wagner","South","Stropo-2",1220.92,null,"",null,""]
[null,"Fischer","East","AA7-FX",1417.52,null,"",null,""]
[null,"Baumgarten","West","XLT-1",665.54,null,"",null,""]
[null,"Wagner","South","WWWz",1108.93,null,"",null,""]
[null,"Schneider","North","BPD-4",768.82,null,"",null,""]
[null,"Müller","North","AA7-FX",1339.58,null,"",null,""]
[null,"Schäfer","West","Stropo-2",699.42,null,"",null,""]
[null,"Fischer","East","Stropo-2",839.87,null,"",null,""]
[null,"Schneider","North","AA7-FX",1129.6199999999999,null,"",null,""]
[null,"Lange","East","Stropo-2",1314.91,null,"",null,""]
[null,"Schulze","South","WWWz",896.72,null,"",null,""]
[null,"Schulze","South","WWWz",734.88,null,"",null,""]
[null,"Müller","North","WWWz",1367.92,null,"",null,""]
[null,"Schulze","South","AA7-FX",887.72,null,"",null,""]
[null,"Becker","South","AA7-FX",792.52,null,"",null,""]

{"sheet":"Example Sales","index":10,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,13,2,19],[4,13,4,15],[4,16,4,18],[0,9,0,10],[1,1,2,5],[4,6,4,7],[4,9,4,10],[3,6,3,7],[3,9,3,10]]}
[null,"Example: Total sales of all employees"]
[null,"Combination of Unique and Sort_"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional solution for the total sales of all employees"]
[null,null,null,null,null,null,"Total sales",null,null,"Total sales"]
[null,"Data",null,null,null,null,"Sorted by employees",null,null,"Sorted by total sales",null,null,null,"UNIQUE",null,null,"SORT"]
[null,"Employee","Region","Product","Sales",null,"Employee","Sales",null,"Employee","Sales",null,null,null,null,null,null,null,"Employee","Sales"]
[null,"Becker","South","WWWz",898.27,null,{"$f":"Sort_(Unique($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":"Sort_(CHOOSE({1,2},Unique($B$7:$B$26),IF(Unique($B$7:$B$26)=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,Unique($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,{"$f":"INDEX($P$7:$P$26,MATCH(R8,$Q$7:$Q$26,0))","v":"Becker"},{"$f":"IF(S8=\"\",\"\",SUMIFS($E$7:$E$26,$B$7:$B$26,S8))","v":1690.79}]
[null,"Schmidt","North","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","East","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","North","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","South","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","East","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","South","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","North","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","North","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","West","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","East","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","North","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","East","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,"",""]
[null,"Schulze","South","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","South","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","North","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","South","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","South","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":"Rand_Array","index":11,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Function Randarray()"]
[null,"Generating an array of random numbers"]
[]
[]
[null,{"$f":"Randarray(10,5,10,20,TRUE)","v":12},17,16,12,19,null,{"$f":"Randarray(10,5,2,4)","v":2.2010122537612915},3.5293717384338379,3.5246399641036987,3.4727952480316162,2.2014495134353638]
[null,15,20,17,11,19,null,3.1711263656616211,2.1701768636703491,3.323782205581665,3.7856956720352173,3.5067667961120605]
[null,15,16,11,19,18,null,2.3981188535690308,3.4353663921356201,3.5647126436233521,2.3284072875976563,3.9571231603622437]
[null,19,17,12,19,17,null,3.1865761280059814,3.5264154672622681,3.2973027229309082,2.9884251356124878,2.778705358505249]
[null,20,19,18,11,20,null,3.1919223070144653,3.4750986099243164,3.4320882558822632,3.0165636539459229,2.2718044519424438]
[null,20,15,14,17,17,null,3.3550810813903809,2.9332541227340698,3.5897262096405029,3.8223363161087036,3.3934268951416016]
[null,11,10,14,11,19,null,3.2483924627304077,3.8537838459014893,3.9017454385757446,3.0404534339904785,3.1515511274337769]
[null,13,17,14,20,10,null,2.1115930080413818,3.7264624834060669,2.2718687057495117,3.8406060934066772,3.3945257663726807]
[null,14,11,12,18,20,null,2.3273712396621704,3.6200213432312012,2.8435114622116089,3.7437198162078857,3.7060586214065552]
[null,19,15,18,18,11,null,2.7051506042480469,2.4245494604110718,2.9913284778594971,2.4910646677017212,3.2666363716125488]

{"sheet":"Sequenz_1","index":12,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[null,"Function Sequence()",null,null,null,null,"Example 1"]
[null,"Generating sequences of numbers"]
[]
[]
[null,{"$f":"Sequence(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":"Sequence_2","index":13,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
[null,"Function Sequence()",null,null,null,"Example 2"]
[null,"Dates Wednesdays fortnightly"]
[]
["First date of the year:",null,"2022-01-05",null,"Year:",2022]
[null,null,null,null,"Weekday:","Wednesday"]
[]
["Sunday",null,{"$f":"Sequence(27,1,$C$4,14)","v":"2022-01-05"},null,null,{"$f":"IF(YEAR(Sequence(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,Sequence(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"}]
["Monday",null,"2022-01-19",null,null,"2022-01-19"]
["Tuesday",null,"2022-02-02",null,null,"2022-02-02"]
["Wednesday",null,"2022-02-16",null,null,"2022-02-16"]
["Thursday",null,"2022-03-02",null,null,"2022-03-02"]
["Friday",null,"2022-03-16",null,null,"2022-03-16"]
["Saturday",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":"XLookup_1","index":14,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Function XLookup()"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","North","AA7-FX",2022,1656.22]
[null,"4.","Maier","East","BPD-4",2021,1543.42]
[null,"5.","Müller","North","Stropo-2",2021,1336.78]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","South","WWWz",2022,1108.93]
[null,"10.","Schneider","North","BPD-4",2020,768.82]
[null,"11.","Müller","North","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","East","Stropo-2",2021,839.87]
[null,"14.","Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","East","Stropo-2",2021,1314.91]
[null,"16.","Schulze","South","WWWz",2019,896.72]
[null,"17.","Schulze","South","WWWz",2022,734.88]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"20.","Becker","South","AA7-FX",2019,792.52]
[]
[]
[null,null,"Last entry of:"]
[null,null,"Müller"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,{"$f":"XLookup($C$27,$C$4:$C$23,$B$4:$G$23,\"Not found\",,-1)","v":"18."},"Müller","North","WWWz",2019,555.91999999999996]

{"sheet":"XLookup_2","index":15,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Function XLookup() und SUM()"]
[null,"References returned as arguments of the SUM function"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2018,898.27]
[null,"2.","Lehmann","West","BPD-4",2018,1508.32]
[null,"3.","Schmidt","North","AA7-FX",2019,1656.22]
[null,"4.","Maier","East","BPD-4",2019,1543.42]
[null,"5.","Müller","North","Stropo-2",2019,1336.78]
[null,"6.","Wagner","South","Stropo-2",2020,1220.92]
[null,"7.","Fischer","East","AA7-FX",2020,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2020,665.54]
[null,"9.","Wagner","South","WWWz",2020,1108.93]
[null,"10.","Schneider","North","BPD-4",2020,768.82]
[null,"11.","Müller","North","AA7-FX",2021,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2021,699.42]
[null,"13.","Fischer","East","Stropo-2",2021,839.87]
[null,"14.","Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","East","Stropo-2",2021,1314.91]
[null,"16.","Schulze","South","WWWz",2022,896.72]
[null,"17.","Schulze","South","WWWz",2022,734.88]
[null,"18.","Müller","North","WWWz",2022,555.91999999999996]
[null,"19.","Schulze","South","AA7-FX",2023,887.72]
[null,"20.","Becker","South","AA7-FX",2023,792.52]
[]
[]
[null,"The Sum of sales",null,null,null,null,null,null,"With function SUMIFS:"]
[null,"from",2020,"to",2022,"is",{"$f":"SUM(XLookup($C$28,$F$5:$F$24,$G$5:$G$24):XLookup($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":"XLookup($C$28,$F$5:$F$24,$B$5:$B$24)","v":"6."},null,{"$f":"XLookup($E$28,$F$5:$F$24,$B$5:$B$24,,,-1)","v":"18."}]

{"sheet":"XLookup_Arr_formulas","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,"Total sales of selected employees"]
[null,null,null,null,null,null,null,null,"List of selected employees:"]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2022,898.27,null,"Müller",null,{"$f":"XLookup($I$5:$I$7,$C$5:$C$24,$B$5:$G$24)","v":"5."},"Müller","North","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","North","AA7-FX",2022,1656.22,null,"Baumgarten",null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"4.","Maier","East","BPD-4",2021,1543.42]
[null,"5.","Müller","North","Stropo-2",2021,1336.78]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","South","WWWz",2022,1108.93,null,null,null,"Summe der Umsätze:",null,{"$f":"SUM(XLookup($I$5:$I$7,$C$5:$C$24,$G$5:$G$24,\"Kein Treffer\"))","v":3510.64}]
[null,"10.","Schneider","North","BPD-4",2020,768.82]
[null,"11.","Müller","North","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","East","Stropo-2",2021,839.87]
[null,"14.","Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","East","Stropo-2",2021,1314.91]
[null,"16.","Schulze","South","WWWz",2019,896.72]
[null,"17.","Schulze","South","WWWz",2022,734.88]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"20.","Becker","South","AA7-FX",2019,792.52]

{"sheet":"XLookup2_1","index":17,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Function XLookup2()"]
[null,"XLOOKUP with multiple search criteria"]
[null,"Returning the first match found"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","South","AA7-FX",2022,1656.22]
[null,"4.","Maier","East","BPD-4",2021,1543.42]
[null,"5.","Müller","North","Stropo-2",2021,1336.78]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","South","WWWz",2022,1108.93]
[null,"10.","Schneider","North","BPD-4",2020,768.82]
[null,"11.","Müller","North","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","East","Stropo-2",2021,839.87]
[null,"14.","Schneider","South","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","East","Stropo-2",2021,1314.91]
[null,"16.","Schulze","South","WWWz",2019,896.72]
[null,"17.","Schulze","South","WWWz",2022,734.88]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"20.","Becker","South","AA7-FX",2019,792.52]
[]
[]
[null,null,"Employee","Region","Product","Year"]
[null,null,"Schneider","South","AA7-FX"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,{"$f":"XLookup2($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","South","AA7-FX",2021,1129.6199999999999]

{"sheet":"Sheet17","index":18,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,"Function XLookup2()"]
[null,"XLOOKUP with multiple search criteria (Wildcard mode)",null,null,null,null,null,null,null,"Mitarbeiter","Region","Produkt","Jahr"]
[null,"Returning of all matches found",null,null,null,null,null,null,null,"sch*","s??th","A*"]
[]
[null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz",null,"Nr.","Mitarbeiter","Region","Produkt","Jahr","Umsatz"]
[null,"1.","Becker","South","WWWz",2022,898.27,null,{"$f":"XLookup2($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","South","AA7-FX",2022,1656.22]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32,null,"14.","Schneider","South","AA7-FX",2021,1129.6199999999999]
[null,"3.","Schmidt","South","AA7-FX",2022,1656.22,null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"4.","Maier","East","BPD-4",2021,1543.42,null,"","","","","",""]
[null,"5.","Müller","North","Stropo-2",2021,1336.78,null,"","","","","",""]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92,null,"","","","","",""]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52,null,"","","","","",""]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54,null,"","","","","",""]
[null,"9.","Wagner","South","WWWz",2022,1108.93,null,"","","","","",""]
[null,"10.","Schneider","North","BPD-4",2020,768.82,null,"","","","","",""]
[null,"11.","Müller","North","AA7-FX",2022,1339.58,null,"","","","","",""]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42,null,"","","","","",""]
[null,"13.","Fischer","East","Stropo-2",2021,839.87,null,"","","","","",""]
[null,"14.","Schneider","South","AA7-FX",2021,1129.6199999999999,null,"","","","","",""]
[null,"15.","Lange","East","Stropo-2",2021,1314.91,null,"","","","","",""]
[null,"16.","Schulze","South","WWWz",2019,896.72,null,"","","","","",""]
[null,"17.","Schulze","South","WWWz",2022,734.88,null,"","","","","",""]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996,null,"","","","","",""]
[null,"19.","Schulze","South","AA7-FX",2020,887.72,null,"","","","","",""]
[null,"20.","Becker","South","AA7-FX",2019,792.52,null,"","","","","",""]

{"sheet":"XLookup2_2","index":19,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Function XLookup2()"]
[null,"XLOOKUP with multiple search criteria (Wildcard mode)",null,null,null,null,null,null,null,"Employee","Region","Product","Year"]
[null,"Return of all matches",null,null,null,null,null,null,null,"sch*","s??th","A*"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales",null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2022,898.27,null,{"$f":"XLookup2($J$3,$C$6:$C$25,$B$6:$G$25,\"nothing\",2,2,$K$3,$D$6:$D$25,$L$3,$E$6:$E$25,$M$3,$F$6:$F$25)","v":"3."},"Schmidt","South","AA7-FX",2022,1656.22]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32,null,"14.","Schneider","South","AA7-FX",2021,1129.6199999999999]
[null,"3.","Schmidt","South","AA7-FX",2022,1656.22,null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"4.","Maier","East","BPD-4",2021,1543.42,null,"","","","","",""]
[null,"5.","Müller","North","Stropo-2",2021,1336.78,null,"","","","","",""]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92,null,"","","","","",""]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52,null,"","","","","",""]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54,null,"","","","","",""]
[null,"9.","Wagner","South","WWWz",2022,1108.93,null,"","","","","",""]
[null,"10.","Schneider","North","BPD-4",2020,768.82,null,"","","","","",""]
[null,"11.","Müller","North","AA7-FX",2022,1339.58,null,"","","","","",""]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42,null,"","","","","",""]
[null,"13.","Fischer","East","Stropo-2",2021,839.87,null,"","","","","",""]
[null,"14.","Schneider","South","AA7-FX",2021,1129.6199999999999,null,"","","","","",""]
[null,"15.","Lange","East","Stropo-2",2021,1314.91,null,"","","","","",""]
[null,"16.","Schulze","South","WWWz",2019,896.72,null,"","","","","",""]
[null,"17.","Schulze","South","WWWz",2022,734.88,null,"","","","","",""]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996,null,"","","","","",""]
[null,"19.","Schulze","South","AA7-FX",2020,887.72,null,"","","","","",""]
[null,"20.","Becker","South","AA7-FX",2019,792.52,null,"","","","","",""]

{"sheet":"XMatch","index":20,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Function XMatch()"]
[]
[null,"Nr.","Employee","Region","Product","Year","Sales"]
[null,"1.","Becker","South","WWWz",2022,898.27]
[null,"2.","Lehmann","West","BPD-4",2021,1508.32]
[null,"3.","Schmidt","North","AA7-FX",2022,1656.22]
[null,"4.","Maier","East","BPD-4",2021,1543.42]
[null,"5.","Müller","North","Stropo-2",2021,1336.78]
[null,"6.","Wagner","South","Stropo-2",2019,1220.92]
[null,"7.","Fischer","East","AA7-FX",2022,1417.52]
[null,"8.","Baumgarten","West","XLT-1",2022,665.54]
[null,"9.","Wagner","South","WWWz",2022,1108.93]
[null,"10.","Schneider","North","BPD-4",2020,768.82]
[null,"11.","Müller","North","AA7-FX",2022,1339.58]
[null,"12.","Schäfer","West","Stropo-2",2019,699.42]
[null,"13.","Fischer","East","Stropo-2",2021,839.87]
[null,"14.","Schneider","North","AA7-FX",2021,1129.6199999999999]
[null,"15.","Lange","East","Stropo-2",2021,1314.91]
[null,"16.","Schulze","South","WWWz",2019,896.72]
[null,"17.","Schulze","South","WWWz",2022,734.88]
[null,"18.","Müller","North","WWWz",2019,555.91999999999996]
[null,"19.","Schulze","South","AA7-FX",2020,887.72]
[null,"20.","Becker","South","AA7-FX",2019,792.52]
[]
[]
[null,null,"The first entry of employee"]
[null,null,"Müller"]
[null,null,"is in position"]
[null,null,{"$f":"XMatch($C$27,$C$4:$C$23)","v":5}]