{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["IFERROR,INDEX,ROWS","IF, ROW, COUNTA, INDEX","INDEX, INT, COLUMNS, MOD, ROW","VBA"],"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":"IFERROR,INDEX,ROWS","index":0,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of IFERROR, INDEX And ROWS Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Products","Merged List",null,null,"Products","Products","Merged List"]
[null,"Hat","Shirt",{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D5:$D$5)), IFERROR(INDEX($C$5:$C$7, ROWS(D5:$D$5)-ROWS($B$5:$B$8)),\"\"))","v":"Hat"},null,null,"Hat","Shirt"]
[null,"Jacket","Sunglass",{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D6)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D6)-ROWS($B$5:$B$8)),\"\"))","v":"Jacket"},null,null,"Jacket","Sunglass"]
[null,"Shoe","Backpack",{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D7)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D7)-ROWS($B$5:$B$8)),\"\"))","v":"Shoe"},null,null,"Shoe","Backpack"]
[null,"Watch",null,{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D8)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D8)-ROWS($B$5:$B$8)),\"\"))","v":"Watch"},null,null,"Watch"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D9)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D9)-ROWS($B$5:$B$8)),\"\"))","v":"Shirt"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D10)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D10)-ROWS($B$5:$B$8)),\"\"))","v":"Sunglass"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$8, ROWS(D$5:$D11)), IFERROR(INDEX($C$5:$C$7, ROWS(D$5:$D11)-ROWS($B$5:$B$8)),\"\"))","v":"Backpack"}]

{"sheet":"IF, ROW, COUNTA, INDEX","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of IF, ROW, COUNTA, INDEX Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Products","Merged List",null,null,"Products","Products","Merged List"]
[null,"Hat","Shirt",{"$f":"IF(B5<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Hat"},null,null,"Hat","Shirt"]
[null,"Jacket","Sunglass",{"$f":"IF(B6<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Jacket"},null,null,"Jacket","Sunglass"]
[null,"Shoe","Backpack",{"$f":"IF(B7<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Shoe"},null,null,"Shoe","Backpack"]
[null,"Watch",null,{"$f":"IF(B8<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Watch"},null,null,"Watch"]
[null,null,null,{"$f":"IF(B9<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Shirt"}]
[null,null,null,{"$f":"IF(B10<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Sunglass"}]
[null,null,null,{"$f":"IF(B11<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Backpack"}]

{"sheet":"INDEX, INT, COLUMNS, MOD, ROW","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of INDEX, INT, COLUMNS, MOD And ROW Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Products","Merged List",null,null,"Products","Products","Merged List"]
[null,"Hat","Shirt",{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B5)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B5)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Hat"},null,null,"Hat","Shirt"]
[null,"Jacket","Sunglass",{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B6)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B6)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Shirt"},null,null,"Jacket","Sunglass"]
[null,"Shoe","Backpack",{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B7)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B7)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Jacket"},null,null,"Shoe","Backpack"]
[null,null,null,{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B8)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B8)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Sunglass"}]
[null,null,null,{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B9)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B9)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Shoe"}]
[null,null,null,{"$f":"INDEX($B$5:$C$7,1+INT((ROW(B10)-5)/COLUMNS($B$5:$C$7)),MOD(ROW(B10)-5+COLUMNS($B$5:$C$7),COLUMNS($B$5:$C$7))+1)","v":"Backpack"}]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of VBA",null,null,"Try Yourself"]
[]
[null,"Products","Products",null,"Products","Products"]
[null,"Hat",null,null,"Hat","Shirt"]
[null,"Jacket",null,null,"Jacket","Sunglass"]
[null,"Shoe",null,null,"Shoe","Backpack"]
[null,"Shirt"]
[null,"Sunglass"]
[null,"Backpack"]