{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Column","Text","Number","CaseSensitive","UNIQUE","COUNTIFS","Remove","PivotTable","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Column","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,4],[16,1,16,2],[1,1,1,4],[16,3,16,4]]}
[]
[null,"Counting Unique Values in Column"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2005–06","Thierry Henry","Forward","Arsenal"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]
[]
[null,"Number of Players",null,{"$f":"SUM(IF(COUNTIF(C6:C15,C6:C15)=1,1,0))","v":4}]

{"sheet":"Text","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[16,1,16,2],[16,3,16,4]]}
[]
[null,"Counting Unique Text Values"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2005–06","Thierry Henry","Forward","Arsenal"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]
[]
[null,"Number of Players",null,{"$f":"SUM(IF(ISTEXT(C6:C15)*COUNTIF(C6:C15,C6:C15)=1,1,0))","v":4}]

{"sheet":"Number","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,5],[1,1,1,5],[15,1,15,3],[15,4,15,5]]}
[]
[null,"Counting Unique Numeric Values"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club","Jersey No"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal",8]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United",10]
[null,"2003–04","Thierry Henry","Forward","Arsenal",14]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea",8]
[null,"2005–06","Thierry Henry","Forward","Arsenal",14]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United",7]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United",7]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United",15]
[null,"2009–10","Wayne Rooney","Forward","Manchester United",10]
[]
[null,"Number of Unique Players Based on Jersey Number",null,null,{"$f":"SUM(IF(ISNUMBER(F5:F14)*COUNTIF(F5:F14,F5:F14)=1,1,0))","v":1}]

{"sheet":"CaseSensitive","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,5],[16,1,16,3],[16,4,16,5]]}
[]
[null,"Counting Case-Sensitive Unique Values"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club","Remarks"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C6)))=1,\"One Time\",\"Multiple Times\")","v":"One Time"}]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C7)))=1,\"One Time\",\"Multiple Times\")","v":"One Time"}]
[null,"2003–04","Thierry Henry","Forward","Arsenal",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C8)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C9)))=1,\"One Time\",\"Multiple Times\")","v":"One Time"}]
[null,"2005–06","Thierry Henry","Forward","Arsenal",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C10)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C11)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C12)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C13)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[null,"2009–10","Wayne Rooney","Forward","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C14)))=1,\"One Time\",\"Multiple Times\")","v":"One Time"}]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United",{"$f":"IF(SUM((--EXACT($C$6:$C$15,C15)))=1,\"One Time\",\"Multiple Times\")","v":"Multiple Times"}]
[]
[null,"Number of One Time Player of the Season Winners",null,null,{"$f":"COUNTIF(F6:F15, \"One Time\")","v":4}]

{"sheet":"UNIQUE","index":4,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[16,1,16,2],[16,3,16,4]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club",null,null,null,null,null,null,"Freddie Ljungberg"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal",null,null,null,null,null,null,"Ruud van Nistelrooy"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United",null,null,null,null,null,null,"Thierry Henry"]
[null,"2003–04","Thierry Henry","Forward","Arsenal",null,null,null,null,null,null,"Frank Lampard"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea",null,null,null,null,null,null,"Thierry Henry "]
[null,"2005–06","Thierry Henry","Forward","Arsenal",null,null,null,null,null,null,"Cristiano Ronaldo"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United",null,null,null,null,null,null,"Cristiano Ronaldo"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United",null,null,null,null,null,null,"Nemanja Vidić"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United",null,null,null,null,null,null,"Wayne Rooney"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United",null,null,null,null,null,null,"Nemanja Vidić"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]
[]
[null,"Number of Distinct Players",null,{"$f":"COUNTA(_xlfn.UNIQUE(C6:C15))","v":7}]

{"sheet":"COUNTIFS","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[16,1,16,2],[16,3,16,4]]}
[]
[null,"Using COUNTIFS Function"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2005–06","Thierry Henry","Forward","Arsenal"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]
[]
[null,"Number of Distinct Players",null,{"$f":"SUM(1/COUNTIFS(C6:C15,C6:C15))","v":7}]

{"sheet":"Remove","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4]]}
[]
[null,"Removing Duplicates"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]

{"sheet":"PivotTable","index":7,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,6]]}
[]
[null,"Using Pivot Table"]
[]
[null,"Premier League Player of the Season Winners",null,null,null,null,"Distinct Count of Player"]
[null,"Season","Player","Position","Club",null,7]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal"]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2005–06","Thierry Henry","Forward","Arsenal"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]

{"sheet":"VBA","index":8,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[16,1,16,2],[16,3,16,4]]}
[]
[null,"Using VBA"]
[]
[null,"Premier League Player of the Season Winners"]
[null,"Season","Player","Position","Club"]
[null,"2001–02","Freddie Ljungberg","Midfielder","Arsenal"]
[null,"2002–03","Ruud van Nistelrooy","Forward","Manchester United"]
[null,"2003–04","Thierry Henry","Forward","Arsenal",null,null,null,{"$f":"COUNTDISTINCTVALUES(C6:C15)","v":{"$error":"#NAME?"}}]
[null,"2004–05","Frank Lampard","Midfielder","Chelsea"]
[null,"2005–06","Thierry Henry","Forward","Arsenal"]
[null,"2006–07","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2007–08","Cristiano Ronaldo","Forward","Manchester United"]
[null,"2008–09","Nemanja Vidić","Defender","Manchester United"]
[null,"2009–10","Wayne Rooney","Forward","Manchester United"]
[null,"2010–11","Nemanja Vidić","Defender","Manchester United"]
[]
[null,"Number of Distinct Players",null,{"$f":"DistinctValueCount(C6:C16)","v":{"$error":"#NAME?"}}]