{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Zeige fehlende Werte"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Zeige fehlende Werte","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Eingabe",null,"Zeile in Spalte A","Kommentar"]
[7,"Start Gesamtliste",{"$f":"MIN(IF(ISNUMBER(Eingabe),ROW(Eingabe),2000000))","v":2},"Muss nicht sortiert sein"]
[8,"Ende Gesamtliste",{"$f":"MAX(IF(ISNUMBER(Eingabe),ROW(Eingabe),0))","v":21}]
[11,"Start Liste 1",{"$f":"MIN(IF(ISNUMBER(Eingabe),ROW(Eingabe),2000000))","v":2},"Muss sortiert sein"]
[12,"Ende Liste 1",{"$f":"1+MATCH(-1,SIGN(OFFSET(Eingabe,2,)-OFFSET(Eingabe,1,)),0)","v":10}]
[13,"Start Liste 2",{"$f":"C5+1","v":11},"Muss nicht sortiert sein"]
[14,"Ende Liste 2",{"$f":"MAX(Start2,IF(ISNUMBER(Eingabe),ROW(Eingabe),0))","v":21}]
[15]
[16,"Fehlende Werte","Resultat Excel 2021/365","Resultat älteres Excel"]
[17,"Gesamtliste",{"$f":"IF(Start<Ende,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--Liste)-MIN(--Liste)+1,,MIN(--Liste)),--Liste,0)),_xlfn.SEQUENCE(MAX(--Liste)-MIN(--Liste)+1,,MIN(--Liste)),\"\")),\"\")","v":"5,9,10"},{"$f":"IF(Start<Ende,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--Liste)&\":\"&MAX(--Liste))),--Liste,0)),ROW(INDIRECT(MIN(--Liste)&\":\"&MAX(--Liste))),\"\")),\"\")","v":"5,9,10"}]
[3,"Liste 1",{"$f":"IF(Start1<Ende1,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--Liste1)-MIN(--Liste1)+1,,MIN(--Liste1)),--Liste1,0)),_xlfn.SEQUENCE(MAX(--Liste1)-MIN(--Liste1)+1,,MIN(--Liste1)),\"\")),\"\")","v":"9,10"},{"$f":"IF(Start<Ende,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--Liste1)&\":\"&MAX(--Liste1))),--Liste1,0)),ROW(INDIRECT(MIN(--Liste1)&\":\"&MAX(--Liste1))),\"\")),\"\")","v":"9,10"}]
[4,"Liste 2",{"$f":"IF(Start2<Ende2,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--Liste2)-MIN(--Liste2)+1,,MIN(--Liste2)),--Liste2,0)),_xlfn.SEQUENCE(MAX(--Liste2)-MIN(--Liste2)+1,,MIN(--Liste2)),\"\")),\"\")","v":"5,7,8,9,10,12"},{"$f":"IF(Start<Ende,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--Liste2)&\":\"&MAX(--Liste2))),--Liste2,0)),ROW(INDIRECT(MIN(--Liste2)&\":\"&MAX(--Liste2))),\"\")),\"\")","v":"5,7,8,9,10,12"}]
[6,null,null,"Vor Excel 2019 bitte"]
[11,null,null,"TEXTVERKETTEN von"]
[19,null,null,"https://www.bplumhoff.de/textverketten_de/"]
[13,null,null,"nehmen"]
[14]
[15]
[16]
[17]
[18]