{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Advance Filtering","UNIQUE function","INDEX MATCH","LOOKUP","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets",null,null,null,null,null,"For Practice"]
[]
[null,"Student ID",null,null,null,null,null,"Student ID"]
[null,1601001,null,null,null,null,null,1601001]
[null,1601002,null,null,null,null,null,1601002]
[null,1601003,null,null,null,null,null,1601003]
[null,1601003,null,null,null,null,null,1601003]
[null,1601005,null,null,null,null,null,1601005]
[null,1601004,null,null,null,null,null,1601004]
[null,1601002,null,null,null,null,null,1601002]
[null,1601003,null,null,null,null,null,1601003]
[null,1601006,null,null,null,null,null,1601006]
[null,1601005,null,null,null,null,null,1601005]
[null,1601007,null,null,null,null,null,1601007]
[null,1601006,null,null,null,null,null,1601006]

{"sheet":"Advance Filtering","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets"]
[]
[null,1601001]
[null,1601002]
[null,1601003]
[null,1601001]
[null,1601005]
[null,1601004]
[null,1601006]
[null,1601007]

{"sheet":"UNIQUE function","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets"]
[]
[null,"Student ID"]
[null,{"$f":"_xlfn.UNIQUE(Dataset!B6:B17)","v":1601001}]
[null,1601002]
[null,1601003]
[null,1601005]
[null,1601004]
[null,1601006]
[null,1601007]

{"sheet":"INDEX MATCH","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets"]
[]
[null,"Student ID"]
[null,{"$f":"INDEX(Dataset!B6:B17, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B5,Dataset!B6:B17),0))","v":1601001}]
[null,{"$f":"INDEX(Dataset!B7:B18, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B6,Dataset!B7:B18),0))","v":1601002}]
[null,{"$f":"INDEX(Dataset!B8:B19, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B7,Dataset!B8:B19),0))","v":1601003}]
[null,{"$f":"INDEX(Dataset!B9:B20, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B8,Dataset!B9:B20),0))","v":1601005}]
[null,{"$f":"INDEX(Dataset!B10:B21, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B9,Dataset!B10:B21),0))","v":1601004}]
[null,{"$f":"INDEX(Dataset!B11:B22, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B10,Dataset!B11:B22),0))","v":1601006}]
[null,{"$f":"INDEX(Dataset!B12:B23, MATCH(0,COUNTIF('INDEX MATCH'!$B$5:B11,Dataset!B12:B23),0))","v":1601007}]

{"sheet":"LOOKUP","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets"]
[]
[null,"Student ID"]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B5,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601006}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B6,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601007}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B7,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601005}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B8,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601003}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B9,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601002}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B10,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601004}]
[null,{"$f":"LOOKUP(2,1/(COUNTIF($B$5:B11,Dataset!$B$6:$B$17)=0),Dataset!$B$6:$B$17)","v":1601001}]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Copying Unique Values to Another Worksheets"]
[]
[null,1601001]
[null,1601002]
[null,1601003]
[null,1601005]
[null,1601004]
[null,1601006]
[null,1601007]