{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","conditional formatting","COUNTIF","IF&COUNTIFS","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Walnut","Lara",3405]
[null,"Cherry","Smith",4316]
[null,"Watermelon","Jefferson",2958]
[null,"Walnut","Lara",3405]
[null,"Jackfruit","Katherine",2154]
[null,"Banana","Peter",2580]
[null,"Apple","Howard",2172]
[null,"Blackberry","Sheldon",4815]
[null,"Apple","Howard",2172]
[null,"Strawberry","Jacob",3914]

{"sheet":"conditional formatting","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using Conditional Formatting"]
[]
[null,"Product","SalesPerson","Sales",null,"Column1 ","Column2 "]
[null,"Walnut","Lara",3405,null,"Walnut","Apple"]
[null,"Cherry","Smith",4316,null,"Lara","Howard"]
[null,"Watermelon","Jefferson",2958,null,3405,2172]
[null,"Walnut","Lara",3405]
[null,"Jackfruit","Katherine",2154]
[null,"Banana","Peter",2580]
[null,"Apple","Howard",2172]
[null,"Blackberry","Sheldon",4815]
[null,"Apple","Howard",2172]
[null,"Strawberry","Jacob",3914]

{"sheet":"COUNTIF","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Using COUNTIF Function"]
[]
[null,"SalesPerson","Sales","Extra1","Extra2",null,"Column1 ","Column2 "]
[null,"Lara",3405,{"$f":"B4&C4","v":"Lara3405"},{"$f":"COUNTIF($D$4:D4,D4)","v":1},null,"Lara","Howard"]
[null,"Smith",4316,{"$f":"B5&C5","v":"Smith4316"},{"$f":"COUNTIF($D$4:D5,D5)","v":1},null,3405,2172]
[null,"Jefferson",2958,"Jefferson2958",{"$f":"COUNTIF($D$4:D6,D6)","v":1}]
[null,"Lara",3405,"Lara3405",{"$f":"COUNTIF($D$4:D7,D7)","v":2}]
[null,"Katherine",2154,"Katherine2154",{"$f":"COUNTIF($D$4:D8,D8)","v":1}]
[null,"Peter",2580,"Peter2580",{"$f":"COUNTIF($D$4:D9,D9)","v":1}]
[null,"Howard",2172,"Howard2172",{"$f":"COUNTIF($D$4:D10,D10)","v":1}]
[null,"Sheldon",4815,"Sheldon4815",{"$f":"COUNTIF($D$4:D11,D11)","v":1}]
[null,"Howard",2172,"Howard2172",{"$f":"COUNTIF($D$4:D12,D12)","v":2}]
[null,"Jacob",3914,"Jacob3914",{"$f":"COUNTIF($D$4:D13,D13)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"IF&COUNTIFS","index":3,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"Using IF & COUNTIFS Function"]
[]
[null,"Product","SalesPerson","Sales","Extra",null,"Column1 ","Column2 "]
[null,"Walnut","Lara",3405,{"$f":"IF(COUNTIFS($B$4:$B$13,$B4,$C$4:$C$13,$C4,$D$4:$D$13,$D4)>1, \"Repeated Row\", \"\")","v":"Repeated Row"},null,"Walnut","Apple"]
[null,"Cherry","Smith",4316,{"$f":"IF(COUNTIFS($B$4:$B$13,$B5,$C$4:$C$13,$C5,$D$4:$D$13,$D5)>1, \"Repeated Row\", \"\")","v":""},null,"Lara","Howard"]
[null,"Watermelon","Jefferson",2958,"",null,3405,2172]
[null,"Walnut","Lara",3405,"Repeated Row"]
[null,"Jackfruit","Katherine",2154,""]
[null,"Banana","Peter",2580,""]
[null,"Apple","Howard",2172,"Repeated Row"]
[null,"Blackberry","Sheldon",4815,""]
[null,"Apple","Howard",2172,"Repeated Row"]
[null,"Strawberry","Jacob",3914,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Code"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Walnut","Lara",3405,3405,"Walnut"]
[null,"Cherry","Smith",4316,null,"Lara"]
[null,"Watermelon","Jefferson",2958,null,3405]
[null,"Jackfruit","Katherine",2154]
[null,"Banana","Peter",2580]
[null,"Apple","Howard",2172,2172,"Apple"]
[null,"Blackberry","Sheldon",4815,null,"Howard"]
[null,"Strawberry","Jacob",3914,null,2172]

{"sheet":"Practice","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Practice"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Walnut","Lara",3405]
[null,"Cherry","Smith",4316]
[null,"Watermelon","Jefferson",2958]
[null,"Walnut","Lara",3405]
[null,"Jackfruit","Katherine",2154]
[null,"Banana","Peter",2580]
[null,"Apple","Howard",2172]
[null,"Blackberry","Sheldon",4815]
[null,"Apple","Howard",2172]
[null,"Strawberry","Jacob",3914]