{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VBA","Formula"],"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":"VBA","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Values","CountConsVal"]
["B",{"$f":"CountConsVal(A2:A25)","v":""},null,"Find the longest/smallest consecutive sequence of a value"]
["B",2,null,"Max:",{"$f":"MAX(CountConsVal(A2:A25))","v":4},"Min:",{"$f":"MIN(CountConsVal(A2:A25))","v":1}]
["C","",null,"Value:",{"$f":"INDEX(A2:A25,MATCH(MAX(CountConsVal(A2:A25)),CountConsVal(A2:A25),0))","v":"B"},"Value:",{"$f":"INDEX(A2:A25,MATCH(MIN(CountConsVal(A2:A25)),CountConsVal(A2:A25),0))","v":"C"}]
["C",2]
["B","",null,"Find the second longest consecutive sequence of a value"]
["B",2,null,"2nd longest:",{"$f":"LARGE(CountConsVal(A2:A25),2)","v":3}]
["C",1,null,"Value:",{"$f":"INDEX(A2:A25,MATCH(LARGE(CountConsVal(A2:A25),2),CountConsVal(A2:A25),0))","v":"C"}]
["B",1]
["C",1]
["B",""]
["B",""]
["B",""]
["B",4]
["C",1]
["B",1]
["A",1]
["C",1]
["A",1]
["C",""]
["C",2]
["A",1]
["C",""]
["C",""]
["C",3]

{"sheet":"Formula","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Values"]
["B",null,"Find the longest/smallest consecutive sequence of a value"]
["B",null,"Max:",{"$f":"MAX(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$25,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1)","v":4},"Min:",{"$f":"MIN(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$25,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1)","v":1}]
["C",null,"Value:",{"$f":"INDEX($A$2:$A$25,SMALL(IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"),MATCH(MAX(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1),FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1,0)))","v":"B"},"Value:",{"$f":"INDEX($A$2:$A$25,SMALL(IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"),MATCH(MIN(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1),FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1,0)))","v":"C"}]
["C"]
["B",null,"Find the second longest consecutive sequence of a value"]
["B",null,"2nd longest:",{"$f":"LARGE(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$25,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1,2)","v":3}]
["C",null,"Value:",{"$f":"INDEX($A$2:$A$25,SMALL(IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"),MATCH(LARGE(FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1,2),FREQUENCY(IF($A$2:$A$25<>$A$3:$A$26,\"\",MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25))),IF($A$2:$A$25<>$A$3:$A$26,MATCH(ROW($A$2:$A$25),ROW($A$2:$A$25)),\"\"))+1,0)))","v":"C"}]
["B"]
["C"]
["B"]
["B"]
["B"]
["B"]
["C"]
["B"]
["A"]
["C"]
["A"]
["C"]
["C"]
["A"]
["C"]
["C"]
["C"]