{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["List missing values"],"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":"List missing values","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Input",null,"Row in Column A","Comment"]
[7,"Start whole List",{"$f":"MIN(IF(ISNUMBER(Input),ROW(Input),2000000))","v":2},"Not necessarily sorted"]
[8,"End whole List",{"$f":"MAX(IF(ISNUMBER(Input),ROW(Input),0))","v":21}]
[11,"Start List 1",{"$f":"MIN(IF(ISNUMBER(Input),ROW(Input),2000000))","v":2},"Has to be sorted"]
[12,"Ende List 1",{"$f":"1+MATCH(-1,SIGN(OFFSET(Input,2,)-OFFSET(Input,1,)),0)","v":10}]
[13,"Start List 2",{"$f":"C5+1","v":11},"Not necessarily sorted"]
[14,"Ende List 2",{"$f":"MAX(Start2,IF(ISNUMBER(Input),ROW(Input),0))","v":21}]
[15]
[16,"Missing Values","Result Excel 2021/365","Result older Excel"]
[17,"Whole List",{"$f":"IF(Start<End,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--List)-MIN(--List)+1,,MIN(--List)),--List,0)),_xlfn.SEQUENCE(MAX(--List)-MIN(--List)+1,,MIN(--List)),\"\")),\"\")","v":"5,9,10"},{"$f":"IF(Start<End,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--List)&\":\"&MAX(--List))),--List,0)),ROW(INDIRECT(MIN(--List)&\":\"&MAX(--List))),\"\")),\"\")","v":"5,9,10"}]
[3,"List 1",{"$f":"IF(Start1<End_1,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--List1)-MIN(--List1)+1,,MIN(--List1)),--List1,0)),_xlfn.SEQUENCE(MAX(--List1)-MIN(--List1)+1,,MIN(--List1)),\"\")),\"\")","v":"9,10"},{"$f":"IF(Start<End,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--List1)&\":\"&MAX(--List1))),--List1,0)),ROW(INDIRECT(MIN(--List1)&\":\"&MAX(--List1))),\"\")),\"\")","v":"9,10"}]
[4,"List 2",{"$f":"IF(Start2<End_2,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(_xlfn.SEQUENCE(MAX(--List2)-MIN(--List2)+1,,MIN(--List2)),--List2,0)),_xlfn.SEQUENCE(MAX(--List2)-MIN(--List2)+1,,MIN(--List2)),\"\")),\"\")","v":"5,7,8,9,10,12"},{"$f":"IF(Start<End,_xlfn.TEXTJOIN(\",\",TRUE,IF(ISNA(MATCH(ROW(INDIRECT(MIN(--List2)&\":\"&MAX(--List2))),--List2,0)),ROW(INDIRECT(MIN(--List2)&\":\"&MAX(--List2))),\"\")),\"\")","v":"5,7,8,9,10,12"}]
[6,null,null,"Before Excel 2019 please"]
[11,null,null,"use TEXTJOIN from"]
[19,null,null,"https://www.sulprobil.com/textjoin_en/"]
[13]
[14]
[15]
[16]
[17]
[18]