{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Advanced Filter","Remove Duplicates","power query files (2)","Power Query","VLOOKUP","INDEX MATCH","MATCH Multiple Columns","VBA","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Advanced Filter","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Advanced Filter "]
[]
[null,"ID ","Name"]
[null,1,"William"]
[null,2,"Garry"]
[null,3,"Olivia"]
[null,4,"Amelia"]
[null,5,"Sophia"]
[null,2,"Garry"]
[]
[]
[]
[null,3,"Olivia"]

{"sheet":"Remove Duplicates","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Remove Duplicates Feature"]
[]
[null,"ID ","Name"]
[null,1,"William"]
[null,2,"Garry"]
[null,3,"Olivia"]
[null,4,"Amelia"]
[null,5,"Sophia"]

{"sheet":"power query files (2)","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source.Name","ID","Name"]
[null,"power query 1.xlsx",1,"William"]
[null,"power query 1.xlsx",2,"Garry"]
[null,"power query 1.xlsx",3,"Olivia"]
[null,"power query 2.xlsx",4,"Amelia"]
[null,"power query 2.xlsx",5,"Sophia"]

{"sheet":"Power Query","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing Power Query"]

{"sheet":"VLOOKUP","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VLOOKUP Function"]
[]
[null,"ID ","Name","Marks",null,"Name","Marks"]
[null,1,"William",null,null,"William",85]
[null,2,"Garry",null,null,"Garry",70]
[null,3,"Olivia",null,null,"Olivia",90]
[null,4,"Amelia",null,null,"Amelia",87]
[null,5,"Sophia",null,null,"Sophia",75]
[null,null,null,null,null,"Richard",83]

{"sheet":"INDEX MATCH","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Combination of INDEX-MATCH Functions"]
[]
[null,"ID ","Name","Marks",null,"Name","Marks"]
[null,1,"William",null,null,"William",85]
[null,2,"Garry",null,null,"Garry",70]
[null,3,"Olivia",null,null,"Olivia",90]
[null,4,"Amelia",null,null,"Amelia",87]
[null,5,"Sophia",null,null,"Sophia",75]
[null,null,null,null,null,"Richard",83]

{"sheet":"MATCH Multiple Columns","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying INDEX-MATCH to Multiple Columns"]
[]
[null,"ID ","Name","Marks",null,"ID ","Name","Marks"]
[null,1,"William",null,null,1,"William",85]
[null,2,"Garry",null,null,2,"Garry",70]
[null,3,"Olivia",null,null,3,"Olivia",90]
[null,4,"Amelia",null,null,4,"Amelia",87]
[null,5,"Sophia",null,null,5,"Sophia",75]
[null,null,null,null,null,3,"Richard",83]

{"sheet":"VBA","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Code"]
[]
[null,"ID ","Name"]
[null,1,"William"]
[null,2,"Garry"]
[null,3,"Olivia"]
[null,4,"Amelia"]
[null,5,"Sophia"]

{"sheet":"Sheet1","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Merging Two Sheets"]
[]
[null,"ID ","Name"]
[null,1,"William"]
[null,2,"Garry"]
[null,3,"Olivia"]
[null,4,"Ameila"]
[null,5,"Sophia"]

{"sheet":"Sheet2","index":9,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Merging Two Sheets"]
[]
[null,"ID ","Name"]
[null,4,"Ameila"]
[null,5,"Sophia"]
[null,3,"Olivia"]