{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Datasheet","Using Remove Duplicate","Using Advanced Filter","Using UNIQUE","Using Power Query","Power Query Output","Using COUNTIF","Using Condition Formatting","Using VBA","Practice "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Datasheet","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Duplicate Rows"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1001,"Jack","Finance"]
[null,1003,"Jack","Marketing"]
[null,1001,"Jack","Finance"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Using Remove Duplicate","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Duplicates Rows"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1001,"Jack","Finance"]
[null,1003,"Jack","Marketing"]
[null,1001,"Jack","Finance"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Using Advanced Filter","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Duplicates Rows"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1001,"Jack","Finance"]
[null,1003,"Jack","Marketing"]
[null,1001,"Jack","Finance"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Using UNIQUE","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Remove Duplicate Rows",null,null,null,"Without Duplicate Values"]
[]
[null,"ID","Name","Major Course",null,{"$f":"_xlfn.UNIQUE(B4:D15)","v":"ID"},"Name","Major Course"]
[null,1001,"Jack","Finance",null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing",null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR",null,1211,"Adam","HR"]
[null,1411,"Bob","HR",null,1411,"Bob","HR"]
[null,1001,"Jack","Finance",null,1003,"Jack","Marketing"]
[null,1003,"Jack","Marketing",null,1522,"Martin","Operation"]
[null,1001,"Jack","Finance",null,1233,"Samuel","Operation"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Using Power Query","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Duplicate Rows"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1001,"Jack","Finance"]
[null,1003,"Jack","Marketing"]
[null,1001,"Jack","Finance"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Power Query Output","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["ID","Name","Major Course"]
[1001,"Jack","Finance"]
[1055,"Jordan","Marketing"]
[1211,"Adam","HR"]
[1411,"Bob","HR"]
[1003,"Jack","Marketing"]
[1522,"Martin","Operation"]
[1233,"Samuel","Operation"]

{"sheet":"Using COUNTIF","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Remove Duplicate Rows"]
[]
[null,"ID","Name","Major Course","Merged ","Count"]
[null,1001,"Jack","Finance",{"$f":"B5&\" \"&C5&\" \"&D5","v":"1001 Jack Finance"},{"$f":"COUNTIF($E$5:$E$11,E5)","v":1}]
[null,1055,"Jordan","Marketing",{"$f":"B6&\" \"&C6&\" \"&D6","v":"1055 Jordan Marketing"},1]
[null,1211,"Adam","HR","1211 Adam HR",1]
[null,1411,"Bob","HR","1411 Bob HR",1]
[null,1003,"Jack","Marketing","1003 Jack Marketing",1]
[null,1522,"Martin","Operation","1522 Martin Operation",1]
[null,1233,"Samuel","Operation","1233 Samuel Operation",1]

{"sheet":"Using Condition Formatting","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Duplicate Rows"]
[]
[null,"ID","Name","Major Course","Merged"]
[null,1001,"Jack","Finance",{"$f":"B5&\" \"&C5&\" \"&D5","v":"1001 Jack Finance"}]
[null,1055,"Jordan","Marketing",{"$f":"B6&\" \"&C6&\" \"&D6","v":"1055 Jordan Marketing"}]
[null,1211,"Adam","HR","1211 Adam HR"]
[null,1411,"Bob","HR","1411 Bob HR"]
[null,1003,"Jack","Marketing","1003 Jack Marketing"]
[null,1522,"Martin","Operation","1522 Martin Operation"]
[null,1233,"Samuel","Operation","1233 Samuel Operation"]

{"sheet":"Using VBA","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Duplicate Rows"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]

{"sheet":"Practice ","index":9,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice Yourself"]
[]
[null,"ID","Name","Major Course"]
[null,1001,"Jack","Finance"]
[null,1055,"Jordan","Marketing"]
[null,1211,"Adam","HR"]
[null,1411,"Bob","HR"]
[null,1001,"Jack","Finance"]
[null,1003,"Jack","Marketing"]
[null,1001,"Jack","Finance"]
[null,1211,"Adam","HR"]
[null,1003,"Jack","Marketing"]
[null,1522,"Martin","Operation"]
[null,1233,"Samuel","Operation"]