{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Formula","Formula1","Advanced","Advanced1","VBA","VBA1","CF","CF1","Pivot","Pivo1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Find Duplicates & Copy to Another Sheet"]
[]
[null,"Fruits","Sold Quantity"]
[null,"Watermelon",20]
[null,"Orange",90]
[null,"Papaya",60]
[null,"Mandarin",100]
[null,"Orange",95]
[null,"Coconut",50]
[null,"Apple",120]
[null,"Rockmelon",40]
[null,"Apple",110]
[null,"Kiwi",100]

{"sheet":"Formula","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Use of IF & COUNTIF Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits","Sold Quantity","Status",null,null,null,null,null,null,null,"Fruits","Sold Quantity"]
[null,"Watermelon",20,{"$f":"IF(COUNTIF($B$5:$B$14,$B5)>1, \"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,null,null,"Watermelon",20]
[null,"Orange",90,{"$f":"IF(COUNTIF($B$5:$B$14,$B6)>1, \"Duplicate\",\"Unique\")","v":"Duplicate"},null,null,null,null,null,null,null,"Orange",90]
[null,"Papaya",60,{"$f":"IF(COUNTIF($B$5:$B$14,$B7)>1, \"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,null,null,"Papaya",60]
[null,"Mandarin",100,"Unique",null,null,null,null,null,null,null,"Mandarin",100]
[null,"Orange",95,"Duplicate",null,null,null,null,null,null,null,"Orange",95]
[null,"Coconut",50,"Unique",null,null,null,null,null,null,null,"Coconut",50]
[null,"Apple",120,"Duplicate",null,null,null,null,null,null,null,"Apple",120]
[null,"Rockmelon",40,"Unique",null,null,null,null,null,null,null,"Rockmelon",40]
[null,"Apple",110,"Duplicate",null,null,null,null,null,null,null,"Apple",110]
[null,"Kiwi",100,"Unique",null,null,null,null,null,null,null,"Kiwi",100]

{"sheet":"Formula1","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of IF & COUNTIF Functions"]
[]
[null,"Fruits","Sold Quantity"]
[null,"Orange",90]
[null,"Orange",95]
[null,"Apple",120]
[null,"Apple",110]

{"sheet":"Advanced","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Advanced Filter"]
[]
[null,"Fruits","Sold Quantity",null,"Criteria range"]
[null,"Watermelon",20]
[null,"Orange",90,null,{"$f":"COUNTIF(B:B,B5)>1","v":false}]
[null,"Papaya",60]
[null,"Mandarin",100,null,"Fruits","Sold Quantity"]
[null,"Orange",95,null,"Orange",90]
[null,"Coconut",50,null,"Orange",95]
[null,"Apple",120,null,"Apple",120]
[null,"Rockmelon",40,null,"Apple",110]
[null,"Apple",110]
[null,"Kiwi",100]

{"sheet":"Advanced1","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Advanced Filter"]
[]
[null,"Fruits","Sold Quantity"]
[null,"Orange",90]
[null,"Orange",95]
[null,"Apple",120]
[null,"Apple",110]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Fruits","Sold Quantity"]
["Watermelon",20]
["Orange",90]
["Papaya",60]
["Mandarin",100]
["Coconut",50]
["Apple",120]
["Rockmelon",40]
["Kiwi",100]

{"sheet":"VBA1","index":6,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Fruits","Sold Quantity"]
["Apple",110]
["Orange",95]

{"sheet":"CF","index":7,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Conditional Formatting",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits","Sold Quantity",null,null,null,null,null,null,null,null,"Fruits","Sold Quantity"]
[null,"Watermelon",20,null,null,null,null,null,null,null,null,"Watermelon",20]
[null,"Orange",90,null,null,null,null,null,null,null,null,"Orange",90]
[null,"Papaya",60,null,null,null,null,null,null,null,null,"Papaya",60]
[null,"Mandarin",100,null,null,null,null,null,null,null,null,"Mandarin",100]
[null,"Orange",95,null,null,null,null,null,null,null,null,"Orange",95]
[null,"Coconut",50,null,null,null,null,null,null,null,null,"Coconut",50]
[null,"Apple",120,null,null,null,null,null,null,null,null,"Apple",120]
[null,"Rockmelon",40,null,null,null,null,null,null,null,null,"Rockmelon",40]
[null,"Apple",110,null,null,null,null,null,null,null,null,"Apple",110]
[null,"Kiwi",100,null,null,null,null,null,null,null,null,"Kiwi",100]

{"sheet":"CF1","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Conditional Formatting"]
[]
[null,"Fruits","Sold Quantity"]
[null,"Orange",90]
[null,"Orange",95]
[null,"Apple",120]
[null,"Apple",110]

{"sheet":"Pivot","index":9,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Pivot Table"]
[]
[null,"Fruits","Sold Quantity",null,"Row Labels","Count of Fruits"]
[null,"Watermelon",20,null,"Orange",2]
[null,"Orange",90,null,"Apple",2]
[null,"Papaya",60,null,"Grand Total",4]
[null,"Mandarin",100]
[null,"Orange",90]
[null,"Coconut",50]
[null,"Apple",120]
[null,"Rockmelon",40]
[null,"Apple",110]
[null,"Kiwi",100]

{"sheet":"Pivo1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}