{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sample Data","Using Data Tab","Advance Filter","Pivot Table","Power Query","Sheet1","Countif","Unique","Conditional","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":1},"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":"Sample Data","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Hawaii","Cashier",null,null,null,"James","Hawaii","Cashier"]
[null,"John","Arizona","Physician",null,null,null,"John","Arizona","Physician"]
[null,"Emma","Alaska","Actor",null,null,null,"Emma","Alaska","Actor"]
[null,"Olivia","Florida","Dentist",null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Using Data Tab","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null," Remove Duplicate Names",null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,"Olivia","Ohio","Dentist"]
[null,"John","Arizona","Physician",null,null,"James","Hawaii","Cashier"]
[null,null,null,null,null,null,"John","Arizona","Physician"]
[null,null,null,null,null,null,"Emma","Alaska","Actor"]
[null,null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Advance Filter","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Hawaii","Cashier",null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"John","Arizona","Physician",null,null,null,null,null,"John","Arizona","Physician"]
[null,"Emma","Alaska","Actor",null,null,null,null,null,"Emma","Alaska","Actor"]
[null,"Olivia","Florida","Dentist",null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Pivot Table","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,10,2,12]]}
[]
[null," Remove Duplicate Names"]
[null,null,null,null,null,null,null,null,null,null,"Practice Here"]
[null,"Names ","States","Occupation",null,null,"Names "]
[null,"James","Texas","Cashier",null,null,"Benjamin",null,null,null,"Names ","States","Occupation"]
[null,"Emma","Alaska","Lawyer",null,null,"Emma",null,null,null,"James","Texas","Cashier"]
[null,"Benjamin","Florida","Waiter",null,null,"James",null,null,null,"Emma","Alaska","Lawyer"]
[null,"Olivia","Ohio","Dentist",null,null,"John",null,null,null,"Benjamin","Florida","Waiter"]
[null,"James","Hawaii","Cashier",null,null,"Olivia",null,null,null,"Olivia","Ohio","Dentist"]
[null,"John","Arizona","Physician",null,null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"Emma","Alaska","Actor",null,null,null,null,null,null,"John","Arizona","Physician"]
[null,"Olivia","Florida","Dentist",null,null,null,null,null,null,"Emma","Alaska","Actor"]
[null,null,null,null,null,null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Power Query","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Hawaii","Cashier",null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"John","Arizona","Physician",null,null,null,null,null,"John","Arizona","Physician"]
[null,"Emma","Alaska","Actor",null,null,null,null,null,"Emma","Alaska","Actor"]
[null,"Olivia","Florida","Dentist",null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Sheet1","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist"]
[null,"John","Arizona","Physician"]

{"sheet":"Countif","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,10,3,12]]}
[]
[null," Remove Duplicate Names"]
[]
[null,"Names ","States","Occupation","Count",null,null,null,null,null,"Practice Here"]
[null,"Benjamin","Florida","Waiter",{"$f":"COUNTIF($B$5:B5,B5)","v":1}]
[null,"Emma","Alaska","Actor",{"$f":"COUNTIF($B$5:B6,B6)","v":1},null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Hawaii","Cashier",{"$f":"COUNTIF($B$5:B7,B7)","v":1},null,null,null,null,null,"James","Texas","Cashier"]
[null,"John","Arizona","Physician",{"$f":"COUNTIF($B$5:B8,B8)","v":1},null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Olivia","Florida","Dentist",{"$f":"COUNTIF($B$5:B9,B9)","v":1},null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Emma","Alaska","Lawyer",{"$f":"COUNTIF($B$5:B10,B10)","v":2},null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Texas","Cashier",{"$f":"COUNTIF($B$5:B11,B11)","v":2},null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"Olivia","Ohio","Dentist",{"$f":"COUNTIF($B$5:B12,B12)","v":2},null,null,null,null,null,"John","Arizona","Physician"]
[null,null,null,null,null,null,null,null,null,null,"Emma","Alaska","Actor"]
[null,null,null,null,null,null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Unique","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Hawaii","Cashier",null,null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"John","Arizona","Physician",null,null,null,null,null,null,"John","Arizona","Physician"]
[null,"Emma","Alaska","Actor",null,null,null,null,null,null,"Emma","Alaska","Actor"]
[null,"Olivia","Florida","Dentist",null,null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"Conditional","index":8,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"James","Hawaii","Cashier",null,null,null,null,null,"James","Hawaii","Cashier"]
[null,"John","Arizona","Physician",null,null,null,null,null,"John","Arizona","Physician"]
[null,"Emma","Alaska","Actor",null,null,null,null,null,"Emma","Alaska","Actor"]
[null,"Olivia","Florida","Dentist",null,null,null,null,null,"Olivia","Florida","Dentist"]

{"sheet":"VBA","index":9,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null," Remove Duplicate Names",null,null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Names ","States","Occupation",null,null,null,null,null,null,null,null,"Names ","States","Occupation"]
[null,"James","Texas","Cashier",null,null,null,null,null,null,null,null,"James","Texas","Cashier"]
[null,"Emma","Alaska","Lawyer",null,null,null,null,null,null,null,null,"Emma","Alaska","Lawyer"]
[null,"Benjamin","Florida","Waiter",null,null,null,null,null,null,null,null,"Benjamin","Florida","Waiter"]
[null,"Olivia","Ohio","Dentist",null,null,null,null,null,null,null,null,"Olivia","Ohio","Dentist"]
[null,"John","Hawaii","Cashier",null,null,null,null,null,null,null,null,"James","Hawaii","Cashier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"John","Arizona","Physician"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Emma","Alaska","Actor"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Olivia","Florida","Dentist"]