{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Conditional","Conditional unique","Conditional countif","VBA","With Power Query","With Power Query (2)","Merge All Values","ViewTwoTablesSideBySide","Compare Two Pivot Tables","Sheet2","Syntex"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Compare Tables in Excel"]
[null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"Conditional","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Using Not Equal (<>) Operator",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[null,"Shop A",null,null,"Shop B",null,null,null,null,null,null,null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price",null,null,null,null,null,null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.99,null,"Red Shirt",22.99,null,null,null,null,null,null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",29.5,null,"Brown Shirt",32.75,null,null,null,null,null,null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5,null,null,null,null,null,null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99,null,null,null,null,null,null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5,null,null,null,null,null,null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99,null,null,null,null,null,null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"Conditional unique","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of Conditional Unique Formatting Rule",null,null,null,null,null,null,"Practice Yourself"]
[null,"Shop A",null,null,"Shop B",null,null,null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price",null,null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.99,null,"Red Shirt",22.99,null,null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",29.5,null,"Brown Shirt",32.75,null,null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5,null,null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99,null,null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5,null,null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99,null,null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"Conditional countif","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using COUNTIF Function ",null,null,null,null,null,null,"Practice Yourself"]
[null,"Shop A",null,null,"Shop B",null,null,null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price",null,null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.5,null,"Red Shirt",22.99,null,null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",32.75,null,"Brown Shirt",32.75,null,null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5,null,null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99,null,null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5,null,null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99,null,null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using VBA",null,null,null,null,null,null,"Practice Yourself"]
[null,"Shop A",null,null,"Shop B",null,null,null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price",null,null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.5,null,"Red Shirt",22.99,null,null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",32.75,null,"Brown Shirt",32.75,null,null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5,null,null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99,null,null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5,null,null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99,null,null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"With Power Query","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,1,1,3]]}
[]
[null,"Compare Tables with Power Query in Excel"]
[null,"Products Record"]
[null,"Item ID","Item","Price"]
[null,1612001,"Red Shirt",22.99]
[null,1612002,"Brown Shirt",29.5]
[null,1612003,"Lavender Shirt",24.5]
[null,1612004,"Yellow Shirt",23.99]
[null,1612005,"Sky Blue Shirt",34.5]
[null,1612006,"Maroon Shirt",40.99]
[null,1612007,"Black Shirt",28.99]
[null,1612008,"Green Shirt",31.99]
[null,1612009,"Blue Shirt",36.99]

{"sheet":"With Power Query (2)","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,3],[2,5,2,7]]}
[]
[null,"Compare Tables with Power Query in Excel"]
[null,"Shop A",null,null,null,"Shop B"]
[null,"Item ID","Item","Price",null,"Item ID","Item","Price"]
[null,1612001,"Red Shirt",22.99,null,1612004,"Yellow Shirt",23.99]
[null,1612002,"Brown Shirt",29.5,null,1612005,"Sky Blue Shirt",34.5]
[null,1612003,"Lavender Shirt",24.5,null,1612006,"Maroon Shirt",40.99]
[null,1612004,"Yellow Shirt",23.99,null,1612007,"Black Shirt",28.99]
[null,1612005,"Sky Blue Shirt",34.5,null,1612008,"Green Shirt",31.99]
[null,1612006,"Maroon Shirt",40.99,null,1612009,"Blue Shirt",36.99]

{"sheet":"Merge All Values","index":7,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Merge All Values"]
["Red Shirt"]
["Brown Shirt"]
["Lavender Shirt"]
["Yellow Shirt"]
["Sky Blue Shirt"]
["Maroon Shirt"]
["Black Shirt"]
["Green Shirt"]
["Blue Shirt"]

{"sheet":"ViewTwoTablesSideBySide","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"View Two Tables Side by Side in Excel"]
[null,"Shop A"]
[null,"Item","Price"]
[null,"Red Shirt",22.99]
[null,"Brown Shirt",29.5]
[null,"Lavender Shirt",24.5]
[null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5]
[null,"Maroon Shirt",24.99]

{"sheet":"Compare Two Pivot Tables","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Compare Two Pivot Tables in Excel"]
[null,"Shop A",null,null,"Shop B"]
[null,"Item","Price",null,"Item","Price"]
[null,"Red Shirt",22.99,null,"Red Shirt",22.99]
[null,"Brown Shirt",29.5,null,"Brown Shirt",32.75]
[null,"Lavender Shirt",24.5,null,"Lavender Shirt",23.5]
[null,"Yellow Shirt",23.99,null,"Yellow Shirt",23.99]
[null,"Sky Blue Shirt",34.5,null,"Sky Blue Shirt",35.5]
[null,"Maroon Shirt",24.99,null,"Maroon Shirt",24.99]

{"sheet":"Sheet2","index":10,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,3,5,4]]}
[]
[]
["Row Labels","Sum of Price"]
["Brown Shirt",29.5]
["Lavender Shirt",24.5]
["Maroon Shirt",24.99,null,"Differences"]
["Red Shirt",22.99,null,"Red Shirt",{"$f":"GETPIVOTDATA(\"Sum of Price\",$A$4,\"Item\",D7)-GETPIVOTDATA(\"Sum of Price\",$A$15,\"Item\",D7)","v":0}]
["Sky Blue Shirt",34.5,null,"Brown Shirt",{"$f":"GETPIVOTDATA(\"Sum of Price\",$A$4,\"Item\",D8)-GETPIVOTDATA(\"Sum of Price\",$A$15,\"Item\",D8)","v":-3.25}]
["Yellow Shirt",23.99,null,"Lavender Shirt",1]
["Grand Total",160.47,null,"Yellow Shirt",0]
[null,null,null,"Sky Blue Shirt",-1]
[null,null,null,"Maroon Shirt",0]
[]
["Row Labels","Sum of Price"]
["Brown Shirt",32.75]
["Lavender Shirt",23.5]
["Maroon Shirt",24.99]
["Red Shirt",22.99]
["Sky Blue Shirt",35.5]
["Yellow Shirt",23.99]
["Grand Total",163.72]

{"sheet":"Syntex","index":11,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[]
[null,"COUNTIF(range, criteria)"]
[null,"Counts the number of cells within a range that meet the given condition"]
[]
[null,"Item","Price",null,"Formula","Result","Remarks"]
[null,"Red Shirt",22.99,null,{"$f":"_xlfn.FORMULATEXT(F6)","v":"=COUNTIF(B6:B11, \"Red Shirt\")"},{"$f":"COUNTIF(B6:B11, \"Red Shirt\")","v":1},"Count the number of cells with Red Shirt in cells B6 through B11."]
[null,"Maroon Shirt",29.5,null,"=COUNTIF(B6:B11, \"Yellow Shirt\")",{"$f":"COUNTIF(B6:B11, \"Yellow Shirt\")","v":1},"Count the number of cells with Yellow Shirt in cells B6 through B11."]
[null,"Lavender Shirt",24,null,"=COUNTIF(C6:C11,\">=24.00\")",{"$f":"COUNTIF(C6:C11,\">=24.00\")","v":4},"Count the number of cells with values greater than and equal to 24.00."]
[null,"Yellow Shirt",23.99,null,"=COUNTIF(C6:C11, \"<=\"&C8)",{"$f":"COUNTIF(C6:C11, \"<=\"&C8)","v":3},"Count the number of cells with values less than and equal to the value of cell C8."]
[null,"Sky Blue Shirt",34.5,null,"=COUNTIF(B6:B11, \"Ma*\")",{"$f":"COUNTIF(B6:B11, \"Ma*\")","v":2},"Count the number of cells with values that start with \"Ma\" characters."]
[null,"Maroon Shirt",24.99,null,"=COUNTIF(B6:B11, \"Re???????\")",{"$f":"COUNTIF(B6:B11, \"Re???????\")","v":1},"Count the number of cells with values that start with \"Re\" characters and then have any seven characters."]