{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sample Dataset","COUNTIFS Function","IF & COUNTIF Functions","Duplicate Values","VBA","IF, ISERROR & MATCH Functions","Advanced Filter"],"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":"Sample Dataset","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Details"]
[]
[null,"Code","Store","Quantity"]
[null,"AA124","Denton",256]
[null,"AA156","Arlington",254]
[null,"AD246","Dallas",254]
[null,"AH463","Denton",125]
[null,"AA156","Arlington",254]
[null,"BC624","Dallas",255]
[null,"BG163","Dallas",222]
[null,"BP266","Arlington",145]
[null,"CY295","Fort Worth",152]
[null,"DM309","Fort Worth",552]
[null,"BP266","Arlington",145]
[null,"ET129","Arlington",257]
[null,"GM234","Dallas",287]

{"sheet":"COUNTIFS Function","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Details"]
[]
[null,"Code","Store","Quantity"]
[null,"AA124","Denton",256]
[null,"AA156","Arlington",254]
[null,"AD246","Dallas",254]
[null,"AH463","Denton",125]
[null,"AA156","Arlington",254]
[null,"BC624","Dallas",255]
[null,"BG163","Dallas",222]
[null,"BP266","Arlington",145]
[null,"CY295","Fort Worth",152]
[null,"DM309","Fort Worth",552]
[null,"BP266","Arlington",145]
[null,"ET129","Arlington",257]
[null,"GM234","Dallas",287]

{"sheet":"IF & COUNTIF Functions","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Product Details"]
[]
[null,"Code","Store","Quantity","Concatenated","Duplicate"]
[null,"AA124","Denton",256,{"$f":"B6&C6&D6","v":"AA124Denton256"},{"$f":"IF(COUNTIF($E$6:$E$18,E6)>1,\"Yes\",\"No\")","v":"No"}]
[null,"AA156","Arlington",254,{"$f":"B7&C7&D7","v":"AA156Arlington254"},{"$f":"IF(COUNTIF($E$6:$E$18,E7)>1,\"Yes\",\"No\")","v":"Yes"}]
[null,"AD246","Dallas",254,"AD246Dallas254",{"$f":"IF(COUNTIF($E$6:$E$18,E8)>1,\"Yes\",\"No\")","v":"No"}]
[null,"AH463","Denton",125,"AH463Denton125",{"$f":"IF(COUNTIF($E$6:$E$18,E9)>1,\"Yes\",\"No\")","v":"No"}]
[null,"AA156","Arlington",254,"AA156Arlington254",{"$f":"IF(COUNTIF($E$6:$E$18,E10)>1,\"Yes\",\"No\")","v":"Yes"}]
[null,"BC624","Dallas",255,"BC624Dallas255",{"$f":"IF(COUNTIF($E$6:$E$18,E11)>1,\"Yes\",\"No\")","v":"No"}]
[null,"BG163","Dallas",222,"BG163Dallas222",{"$f":"IF(COUNTIF($E$6:$E$18,E12)>1,\"Yes\",\"No\")","v":"No"}]
[null,"BP266","Arlington",145,"BP266Arlington145",{"$f":"IF(COUNTIF($E$6:$E$18,E13)>1,\"Yes\",\"No\")","v":"Yes"}]
[null,"CY295","Fort Worth",152,"CY295Fort Worth152",{"$f":"IF(COUNTIF($E$6:$E$18,E14)>1,\"Yes\",\"No\")","v":"No"}]
[null,"DM309","Fort Worth",552,"DM309Fort Worth552",{"$f":"IF(COUNTIF($E$6:$E$18,E15)>1,\"Yes\",\"No\")","v":"No"}]
[null,"BP266","Arlington",145,"BP266Arlington145",{"$f":"IF(COUNTIF($E$6:$E$18,E16)>1,\"Yes\",\"No\")","v":"Yes"}]
[null,"ET129","Arlington",257,"ET129Arlington257",{"$f":"IF(COUNTIF($E$6:$E$18,E17)>1,\"Yes\",\"No\")","v":"No"}]
[null,"GM234","Dallas",287,"GM234Dallas287",{"$f":"IF(COUNTIF($E$6:$E$18,E18)>1,\"Yes\",\"No\")","v":"No"}]

{"sheet":"Duplicate Values","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Details"]
[]
[null,"Code","Store","Quantity"]
[null,"AA124","Denton",256]
[null,"AA156","Arlington",254]
[null,"AD246","Dallas",254]
[null,"AH463","Denton",125]
[null,"AA156","Arlington",254]
[null,"BC624","Dallas",255]
[null,"BG163","Dallas",222]
[null,"BP266","Arlington",145]
[null,"CY295","Fort Worth",152]
[null,"DM309","Fort Worth",552]
[null,"BP266","Arlington",145]
[null,"ET129","Arlington",257]
[null,"GM234","Dallas",287]

{"sheet":"VBA","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Details"]
[]
[null,"Stock",null,"Orders"]
[null,"AA124",null,"AA124"]
[null,"AA156",null,"AA156"]
[null,"AD246",null,"AD246"]
[null,"AH463",null,"AR213"]
[null,"AA156",null,"BC624"]
[null,"BC624",null,"BG163"]
[null,"BG163",null,"BK226"]
[null,"BP266",null,"CY295"]
[null,"CY295",null,"DN335"]
[null,"DM309",null,"ET129"]
[null,"BP266",null,"GM234"]
[null,"ET129",null,"JL394"]
[null,"GM234",null,"MN119"]

{"sheet":"IF, ISERROR & MATCH Functions","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Details"]
[]
[null,"Stock","Orders","Duplicate"]
[null,"AA124","AA124",{"$f":"IF(ISERROR(MATCH(C6,$B$6:$B$18,0)),\"No\",\"Yes\")","v":"Yes"}]
[null,"AA156","AA156",{"$f":"IF(ISERROR(MATCH(C7,$B$6:$B$18,0)),\"No\",\"Yes\")","v":"Yes"}]
[null,"AD246","AD246","Yes"]
[null,"AH463","AR213","No"]
[null,"AA156","BC624","Yes"]
[null,"BC624","BG163","Yes"]
[null,"BG163","BK226","No"]
[null,"BP266","CY295","Yes"]
[null,"CY295","DN335","No"]
[null,"DM309","ET129","Yes"]
[null,"BP266","GM234","Yes"]
[null,"ET129","JL394","No"]
[null,"GM234","MN119","No"]

{"sheet":"Advanced Filter","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Remove Duplicate Rows Based on Two Columns"]
[]
[null,"Code","Store",null,"Code","Store"]
[null,"AA124","Denton",null,"AA124","Denton"]
[null,"AA156","Arlington",null,"AA156","Arlington"]
[null,"AD246","Dallas",null,"AD246","Dallas"]
[null,"AH463","Denton",null,"AH463","Denton"]
[null,"AA156","Arlington",null,"BC624","Dallas"]
[null,"BC624","Dallas",null,"BG163","Dallas"]
[null,"BG163","Dallas",null,"BP266","Arlington"]
[null,"BP266","Arlington",null,"CY295","Fort Worth"]
[null,"CY295","Fort Worth",null,"DM309","Fort Worth"]
[null,"DM309","Fort Worth",null,"ET129","Arlington"]
[null,"BP266","Arlington",null,"GM234","Dallas"]
[null,"ET129","Arlington"]
[null,"GM234","Dallas"]