{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","COUNTIF Function","SUM and IF Functions","Excel VBA"],"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":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Player Name","Ballon d'Or Winner"]
[null,"Karim Benzema",2022]
[null,"Lionel Messi",2021]
[null,"Lionel Messi",2019]
[null,"Luka Modric",2018]
[null,"Cristiano Ronaldo",2017]
[null,"Cristiano Ronaldo",2016]
[null,"Lionel Messi",2015]
[null,"Cristiano Ronaldo",2014]
[null,"Cristiano Ronaldo",2013]

{"sheet":"COUNTIF Function","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Utilizing COUNTIF Function",null,null,null,null,null,null,null,null,"Try Yoursef"]
[]
[null,"Player Name","Ballon d'Or Winner",null,null,null,null,null,null,null,"Player Name","Ballon d'Or Winner"]
[null,"Karim Benzema",2022,null,null,null,null,null,null,null,"Karim Benzema",2022]
[null,"Lionel Messi",2021,null,null,null,null,null,null,null,"Lionel Messi",2021]
[null,"Lionel Messi",2019,null,null,null,null,null,null,null,"Lionel Messi",2019]
[null,"Luka Modric",2018,null,null,null,null,null,null,null,"Luka Modric",2018]
[null,"Cristiano Ronaldo",2017,null,null,null,null,null,null,null,"Cristiano Ronaldo",2017]
[null,"Cristiano Ronaldo",2016,null,null,null,null,null,null,null,"Cristiano Ronaldo",2016]
[null,"Lionel Messi",2015,null,null,null,null,null,null,null,"Lionel Messi",2015]
[null,"Cristiano Ronaldo",2014,null,null,null,null,null,null,null,"Cristiano Ronaldo",2014]
[null,"Cristiano Ronaldo",2013,null,null,null,null,null,null,null,"Cristiano Ronaldo",2013]
[]
[null,"Unique Name","Frequency",null,null,null,null,null,null,null,"Unique Name","Frequency"]
[null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"Karim Benzema"},{"$f":"COUNTIF(B5:B13,B16)","v":1}]
[null,"Lionel Messi",{"$f":"COUNTIF(B6:B14,B17)","v":3}]
[null,"Luka Modric",1]
[null,"Cristiano Ronaldo",4]

{"sheet":"SUM and IF Functions","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Combining SUM and IF Function",null,null,null,null,null,null,null,null,"Try Yoursef"]
[]
[null,"Player Name","Ballon d'Or Winner",null,null,null,null,null,null,null,"Player Name","Ballon d'Or Winner"]
[null,"Karim Benzema",2022,null,null,null,null,null,null,null,"Karim Benzema",2022]
[null,"Lionel Messi",2021,null,null,null,null,null,null,null,"Lionel Messi",2021]
[null,"Lionel Messi",2019,null,null,null,null,null,null,null,"Lionel Messi",2019]
[null,"Luka Modric",2018,null,null,null,null,null,null,null,"Luka Modric",2018]
[null,"Cristiano Ronaldo",2017,null,null,null,null,null,null,null,"Cristiano Ronaldo",2017]
[null,"Cristiano Ronaldo",2016,null,null,null,null,null,null,null,"Cristiano Ronaldo",2016]
[null,"Lionel Messi",2015,null,null,null,null,null,null,null,"Lionel Messi",2015]
[null,"Cristiano Ronaldo",2014,null,null,null,null,null,null,null,"Cristiano Ronaldo",2014]
[null,"Cristiano Ronaldo",2013,null,null,null,null,null,null,null,"Cristiano Ronaldo",2013]
[]
[null,"Unique Name","Frequency",null,null,null,null,null,null,null,"Unique Name","Frequency"]
[null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"Karim Benzema"},{"$f":"SUM(IF($B$5:$B$13=B16,1,0))","v":1}]
[null,"Lionel Messi",{"$f":"SUM(IF($B$5:$B$13=B17,1,0))","v":3}]
[null,"Luka Modric",{"$f":"SUM(IF($B$5:$B$13=B18,1,0))","v":1}]
[null,"Cristiano Ronaldo",{"$f":"SUM(IF($B$5:$B$13=B19,1,0))","v":4}]

{"sheet":"Excel VBA","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Running Excel VBA Code",null,null,null,null,null,null,null,null,"Try Yoursef"]
[]
[null,"Player Name","Ballon d'Or Winner",null,null,null,null,null,null,null,"Player Name","Ballon d'Or Winner"]
[null,"Karim Benzema",2022,null,null,null,null,null,null,null,"Karim Benzema",2022]
[null,"Lionel Messi",2021,null,null,null,null,null,null,null,"Lionel Messi",2021]
[null,"Lionel Messi",2019,null,null,null,null,null,null,null,"Lionel Messi",2019]
[null,"Luka Modric",2018,null,null,null,null,null,null,null,"Luka Modric",2018]
[null,"Cristiano Ronaldo",2017,null,null,null,null,null,null,null,"Cristiano Ronaldo",2017]
[null,"Cristiano Ronaldo",2016,null,null,null,null,null,null,null,"Cristiano Ronaldo",2016]
[null,"Lionel Messi",2015,null,null,null,null,null,null,null,"Lionel Messi",2015]
[null,"Cristiano Ronaldo",2014,null,null,null,null,null,null,null,"Cristiano Ronaldo",2014]
[null,"Cristiano Ronaldo",2013,null,null,null,null,null,null,null,"Cristiano Ronaldo",2013]
[]
[null,"Unique Name","Frequency",null,null,null,null,null,null,null,"Unique Name","Frequency"]
[null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"Karim Benzema"},{"$f":"COUNTIF(B5:B13,B16)","v":1}]
[null,"Lionel Messi",{"$f":"COUNTIF(B6:B14,B17)","v":3}]
[null,"Luka Modric",1]
[null,"Cristiano Ronaldo",4]