{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","VBA","Helper Column","Dynamic Array","TEXT Function"],"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":"Dataset","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Product Name","Product ID"]
[null,"Denim Jacket","109D"]
[null,"Puffer Jacket","549X"]
[null,"Leather Jacket","220B"]
[null,"Sports Jacket","433F"]
[null,"Waterproof Jacket","760P"]
[null,"Overcoat","321A"]

{"sheet":"VBA","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying VBA",null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Product ID","Sorted Numbers with Suffix",null,null,null,"Product Name","Product ID","Sorted Numbers with Suffix"]
[null,"Denim Jacket","109D",109,null,null,null,"Denim Jacket","109D"]
[null,"Leather Jacket","220B",220,null,null,null,"Leather Jacket","220B"]
[null,"Overcoat","321A",321,null,null,null,"Overcoat","321A"]
[null,"Sports Jacket","433F",433,null,null,null,"Sports Jacket","433F"]
[null,"Puffer Jacket","549X",549,null,null,null,"Puffer Jacket","549X"]
[null,"Waterproof Jacket","760P",760,null,null,null,"Waterproof Jacket","760P"]

{"sheet":"Helper Column","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Inserting Helper Column",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Product ID","Number","Suffix",null,null,null,"Product Name","Product ID","Number","Suffix"]
[null,"Denim Jacket","109-D",{"$f":"VALUE(LEFT(C5,FIND(\"-\",C5)-1))","v":109},{"$f":"RIGHT(C5,LEN(C5)-FIND(\"-\",C5))","v":"D"},null,null,null,"Denim Jacket","109-D"]
[null,"Puffer Jacket","220-B",220,"B",null,null,null,"Puffer Jacket","220-B"]
[null,"Leather Jacket","321-A",321,"A",null,null,null,"Leather Jacket","321-A"]
[null,"Waterproof Jacket","433-F",433,"F",null,null,null,"Waterproof Jacket","433-F"]
[null,"Sports Jacket","549-X",549,"X",null,null,null,"Sports Jacket","549-X"]
[null,"Overcoat","760-P",760,"P",null,null,null,"Overcoat","760-P"]

{"sheet":"Dynamic Array","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Creating Dynamic Array",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Sort Column 1","Dynamic Array Formula","Rank Column","Sort Column 2",null,null,null,"Product ID","Sort Column 1","Dynamic Array Formula","Rank Column","Sort Column 2"]
[null,"109D",{"$f":"_xlfn._xlws.SORT(B5:B10)","v":"109D"},{"$f":"IF(ISTEXT(C5:C10),VALUE(LEFT(C5:C10,LEN(C5:C10)-1)),C5:C10)","v":109},{"$f":"_xlfn.RANK.EQ(D5,_xlfn.ANCHORARRAY(D$5),1)","v":1},{"$f":"_xlfn.SORTBY(_xlfn.ANCHORARRAY(C5),E5:E10,1)","v":"109D"},null,null,null,"109D"]
[null,"220B","220B",220,{"$f":"_xlfn.RANK.EQ(D6,_xlfn.ANCHORARRAY(D$5),1)","v":2},"220B",null,null,null,"220B"]
[null,"321A","321A",321,3,"321A",null,null,null,"321A"]
[null,"549X","433F",433,4,"433F",null,null,null,"549X"]
[null,"433F","549X",549,5,"549X",null,null,null,"433F"]
[null,"760P","760P",760,6,"760P",null,null,null,"760P"]

{"sheet":"TEXT Function","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Product ID","Sorted Numbers with Suffix",null,null,null,"Product Name","Product ID","Sorted Numbers with Suffix"]
[null,"Denim Jacket","109D","109D",null,null,null,"Denim Jacket","109D"]
[null,"Leather Jacket","220B","220B",null,null,null,"Leather Jacket","220B"]
[null,"Overcoat","321A","321A",null,null,null,"Overcoat","321A"]
[null,"Sports Jacket","433F","433F",null,null,null,"Sports Jacket","433F"]
[null,"Puffer Jacket","549X","549X",null,null,null,"Puffer Jacket","549X"]
[null,"Waterproof Jacket","760P","760P",null,null,null,"Waterproof Jacket","760P"]