{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["dataset","countif","conditional formatting","Sheet2","pivot table","remove duplicates","vba1","vba2","advanced filter","unique","pqe","Table2","Table4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"dataset","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Removing Duplicate Names"]
[]
[null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"countif","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,14]]}
[]
[null,"Using COUNTIF Function",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired","Helper",null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",{"$f":"COUNTIF($B$5:B5,B5)","v":1},null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",{"$f":"COUNTIF($B$5:B6,B6)","v":1},null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",{"$f":"COUNTIF($B$5:B7,B7)","v":1},null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",{"$f":"COUNTIF($B$5:B8,B8)","v":1},null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"conditional formatting","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Highlighting Duplicates by Conditional Formatting",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes",null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"Sheet2","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Sales"]
["Alberik",8318.5400000000009]
["Gabriellia",7039.58]
["Melosa",6699.7199999999993]
["Regan",9184.25]
["Grand Total",31242.09]

{"sheet":"pivot table","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Use of Pivot Table",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes",null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"remove duplicates","index":5,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Remove Duplicates Feature",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",4852.53,"Yes",null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"vba1","index":6,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Removing from Fixed Range Using VBA",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"vba2","index":7,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,13,1,16]]}
[]
[null,"Removing from Selected Range Using VBA",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,null,null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"advanced filter","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Advanced Filter Command"]
[]
[null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"unique","index":9,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,13,1,16]]}
[]
[null,"Use of UNIQUE Function",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,{"$f":"_xlfn.UNIQUE(B4:E14)","v":"Names"},"State","Sales","Target Acquired",null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,"Alberik","Missouri",2197.77,"Yes",null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,"Regan","Florida",2165.86,"No",null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,"Gabriellia","Texas",3950.19,"No",null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,"Alberik","Missouri",3923,"Yes",null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,"Regan","Florida",4852.53,"Yes",null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes",null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes",null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]

{"sheet":"pqe","index":10,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,13,1,16]]}
[]
[null,"Application of Power Query Editor",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Names","State","Sales","Target Acquired",null,null,null,null,null,null,null,null,"Names","State","Sales","Target Acquired"]
[null,"Melosa","Connecticut",4832.4399999999996,"Yes",null,null,null,null,null,null,null,null,"Melosa","Connecticut",4832.4399999999996,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Gabriellia","Texas",3089.39,"Yes",null,null,null,null,null,null,null,null,"Gabriellia","Texas",3089.39,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Gabriellia","Texas",3950.19,"No",null,null,null,null,null,null,null,null,"Gabriellia","Texas",3950.19,"No"]
[null,"Alberik","Missouri",3923,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",3923,"Yes"]
[null,"Regan","Florida",2165.86,"No",null,null,null,null,null,null,null,null,"Regan","Florida",2165.86,"No"]
[null,"Alberik","Missouri",2197.77,"Yes",null,null,null,null,null,null,null,null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Regan","Florida",4852.53,"Yes",null,null,null,null,null,null,null,null,"Regan","Florida",4852.53,"Yes"]
[null,"Melosa","Connecticut",1867.28,"Yes",null,null,null,null,null,null,null,null,"Melosa","Connecticut",1867.28,"Yes"]
[null,"Alberik","Missouri",2197.77,"Yes"]
[null,"Joseph","Washington",3022.21,"No"]

{"sheet":"Table2","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Names","State","Sales","Target Acquired"]
["Melosa","Connecticut",4832.4399999999996,"Yes"]
["Alberik","Missouri",2197.77,"Yes"]
["Gabriellia","Texas",3089.39,"Yes"]
["Regan","Florida",2165.86,"No"]
["Gabriellia","Texas",3950.19,"No"]
["Alberik","Missouri",3923,"Yes"]
["Regan","Florida",4852.53,"Yes"]
["Melosa","Connecticut",1867.28,"Yes"]
["Joseph","Washington",3022.21,"No"]

{"sheet":"Table4","index":12,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Names","State","Sales","Target Acquired"]
["Alberik","Missouri",2197.77,"Yes"]
["Regan","Florida",2165.86,"No"]
["Regan","Florida",2165.86,"No"]
["Alberik","Missouri",2197.77,"Yes"]