{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data Set","COUNTIF","COUNTIFS","SUMPRODUCT","Case_Sensitive","SUM_LEN_SUBSTITUTE","Count_Order","Exclude_1st_Occu","IF&COUNTIF","Total_Repeated","SUMPRODUCT&COUNTIF","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":"Data Set","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]

{"sheet":"COUNTIF","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"COUNTIF Function to Count Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"COUNTIF(C5:C14,C16)","v":3}]

{"sheet":"COUNTIFS","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"COUNTIFS Function to Count Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"COUNTIFS(C5:C14,C16)","v":3}]

{"sheet":"SUMPRODUCT","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SUMPRODUCT Function"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"SUMPRODUCT(--(C16=C5:C14))","v":3}]

{"sheet":"Case_Sensitive","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Case Sensitive Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","Banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"SUM(--EXACT(C5:C14,C16))","v":3}]

{"sheet":"SUM_LEN_SUBSTITUTE","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of SUM, LEN, and SUBSTITUTE Function"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"SUMPRODUCT(LEN(C5:C14)-LEN(SUBSTITUTE(C5:C14,C16,\"\")))/LEN(C16)","v":2}]

{"sheet":"Count_Order","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Count the Order of Occurrences"]
[]
[null,"Name","Fruit","Order"]
[null,"Allisa","Banana",{"$f":"COUNTIF($C$5:$C5,C5)","v":1}]
[null,"Joe","Apple",{"$f":"COUNTIF($C$5:$C6,C6)","v":1}]
[null,"Josef","Banana",{"$f":"COUNTIF($C$5:$C7,C7)","v":2}]
[null,"John","Pineapple",{"$f":"COUNTIF($C$5:$C8,C8)","v":1}]
[null,"Jessica","Grapes",{"$f":"COUNTIF($C$5:$C9,C9)","v":1}]
[null,"Rogers","Guava",{"$f":"COUNTIF($C$5:$C10,C10)","v":1}]
[null,"Mitchel","banana",{"$f":"COUNTIF($C$5:$C11,C11)","v":3}]
[null,"Aaron","Guava",{"$f":"COUNTIF($C$5:$C12,C12)","v":2}]
[null,"Gerg","Apple",{"$f":"COUNTIF($C$5:$C13,C13)","v":2}]
[null,"Jose","Apple",{"$f":"COUNTIF($C$5:$C14,C14)","v":3}]

{"sheet":"Exclude_1st_Occu","index":7,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Repeated Words Without 1st Occurrences"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Fruit","Banana"]
[null,"Count",{"$f":"COUNTIF(C5:C14,C16)-1","v":2}]

{"sheet":"IF&COUNTIF","index":8,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2]]}
[]
[null,"Combination of IF and COUNTIF Function"]
[]
[null,"Name","Fruit","Status"]
[null,"Allisa","Banana",{"$f":"IF(COUNTIF($C$5:$C5,C5)>1,\"Repeated\",\" \")","v":" "}]
[null,"Joe","Apple",{"$f":"IF(COUNTIF($C$5:$C6,C6)>1,\"Repeated\",\" \")","v":" "}]
[null,"Josef","Banana",{"$f":"IF(COUNTIF($C$5:$C7,C7)>1,\"Repeated\",\" \")","v":"Repeated"}]
[null,"John","Pineapple",{"$f":"IF(COUNTIF($C$5:$C8,C8)>1,\"Repeated\",\" \")","v":" "}]
[null,"Jessica","Grapes",{"$f":"IF(COUNTIF($C$5:$C9,C9)>1,\"Repeated\",\" \")","v":" "}]
[null,"Rogers","Guava",{"$f":"IF(COUNTIF($C$5:$C10,C10)>1,\"Repeated\",\" \")","v":" "}]
[null,"Mitchel","banana",{"$f":"IF(COUNTIF($C$5:$C11,C11)>1,\"Repeated\",\" \")","v":"Repeated"}]
[null,"Aaron","Guava",{"$f":"IF(COUNTIF($C$5:$C12,C12)>1,\"Repeated\",\" \")","v":"Repeated"}]
[null,"Gerg","Apple",{"$f":"IF(COUNTIF($C$5:$C13,C13)>1,\"Repeated\",\" \")","v":"Repeated"}]
[null,"Jose","Apple",{"$f":"IF(COUNTIF($C$5:$C14,C14)>1,\"Repeated\",\" \")","v":"Repeated"}]
[]
[null,"Total",null,{"$f":"COUNTIF(D5:D14,\"Repeated\")","v":5}]

{"sheet":"Total_Repeated","index":9,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Total Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Count",{"$f":"ROWS($C$5:$C$14)-SUM(IF(COUNTIF(C5:$C$14,C5:$C$14)=1,1,0))","v":8}]

{"sheet":"SUMPRODUCT&COUNTIF","index":10,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of SUMPRODUCT and COUNTIF"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Count",{"$f":"SUMPRODUCT(--(COUNTIF(C5:C14,C5:C14)>1))","v":8}]

{"sheet":"VBA","index":11,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA to Count Repeated Words"]
[]
[null,"Name","Fruit"]
[null,"Allisa","Banana"]
[null,"Joe","Apple"]
[null,"Josef","Banana"]
[null,"John","Pineapple"]
[null,"Jessica","Grapes"]
[null,"Rogers","Guava"]
[null,"Mitchel","banana"]
[null,"Aaron","Guava"]
[null,"Gerg","Apple"]
[null,"Jose","Apple"]
[]
[null,"Count",{"$f":"SUMPRODUCT(--(COUNTIF(C5:C14,C5:C14)>1))","v":8}]