{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Count Word Frequency- Examples","Count word frequency","Custom delimiter","Within one cell","Compare frequencies","Compare frequencies 2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"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":"Count Word Frequency- Examples","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,2]]}
[]
[]
[]
[null,"How to Count Frequency of Word in Excel"]
[]
[null,"The workbook shows how to count frequency of words in Excel using a custom function."]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-09-19"]
[null,"Tutorial URL","Excel word frequency analysis with custom function"]
[]
[null,"Examples:"]
["• ","Count frequency of words in a range"]
["• ","Word frequency analysis with custom delimiter"]
["• ","Count frequency of text within one cell"]
["• ","Compare frequency of words in two columns"]
["• ","Compare frequency of words in two cells "]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Count word frequency","index":1,"n_rows":104,"n_cols":4,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Count frequency of words in Excel "]
["Address",null,"Unique words","Count"]
["Sayre Street  Anderson  NC ",null,{"$f":"FreqWords(A3:A26)","v":"CA"},4]
["2121 Falulkner R-d  Atlanta  GA ",null,"IN",4]
["16253 SE 122nd Avn  Clackamas  OR ",null,"OH",3]
["457 Cleveland Av  Columbus  OH ",null,"Denver",3]
["27201 S, Wilmington Avenue  Compton  CA ",null,"CO",3]
["2840 Pioneer Drive  Bowling Green  KY ",null,"St",3]
["400 S.Shortridge Road  Indianapolis  IN ",null,"Rd",2]
["2201 S.Wilmington Ave  Compton  CA ",null,"Av",2]
["1290 Industrial Dr.  Springfield  TN ",null,"Avenue",2]
["1100 New Salem Hwy  Murfreesboro  TN ",null,"Compton",2]
["6801 English Ave  Indianapolis  IN ",null,"Indianapolis",2]
["409 Yuma Str  Denver  CO ",null,"Ave",2]
["1225  Broadway St.  Greensburg  IN ",null,"Dr",2]
["60 Yuma Blv.  Denver  CO ",null,"TN",2]
["10241 East 51st Avenue  Denver  CO ",null,"Yuma",2]
["777 S.Harbor Blvd  LaHabra  CA ",null,"Str",2]
["590 N. Sugar St. Bldg. 5  Layton  UT ",null,"Sugar",2]
["800 Englewood Drv.  Crawsfordsville  IN ",null,"Layton",2]
["2700 Valley High Dr. NW  Rochester  MN ",null,"UT",2]
["813 Bookman Av  Pontiac  SC ",null,"Cincinnati",2]
["1500 Eastride Aven.  Riverside  CA ",null,"Sayre",1]
["500 North Sugar Str.  Layton  UT ",null,"Street",1]
["11801 Chesterdale Rd  Cincinnati  OH ",null,"Anderson",1]
["1034 Depot St  Cincinnati  OH ",null,"NC",1]
[null,null,"2121",1]
[null,null,"Falulkner",1]
[null,null,"Atlanta",1]
[null,null,"GA",1]
[null,null,"16253",1]
[null,null,"SE",1]
[null,null,"122nd",1]
[null,null,"Avn",1]
[null,null,"Clackamas",1]
[null,null,"OR",1]
[null,null,"457",1]
[null,null,"Cleveland",1]
[null,null,"Columbus",1]
[null,null,"27201",1]
[null,null,"S",1]
[null,null,"Wilmington",1]
[null,null,"2840",1]
[null,null,"Pioneer",1]
[null,null,"Drive",1]
[null,null,"Bowling",1]
[null,null,"Green",1]
[null,null,"KY",1]
[null,null,"400",1]
[null,null,"SShortridge",1]
[null,null,"Road",1]
[null,null,"2201",1]
[null,null,"SWilmington",1]
[null,null,"1290",1]
[null,null,"Industrial",1]
[null,null,"Springfield",1]
[null,null,"1100",1]
[null,null,"New",1]
[null,null,"Salem",1]
[null,null,"Hwy",1]
[null,null,"Murfreesboro",1]
[null,null,"6801",1]
[null,null,"English",1]
[null,null,"409",1]
[null,null,"1225",1]
[null,null,"Broadway",1]
[null,null,"Greensburg",1]
[null,null,"60",1]
[null,null,"Blv",1]
[null,null,"10241",1]
[null,null,"East",1]
[null,null,"51st",1]
[null,null,"777",1]
[null,null,"SHarbor",1]
[null,null,"Blvd",1]
[null,null,"LaHabra",1]
[null,null,"590",1]
[null,null,"N",1]
[null,null,"Bldg",1]
[null,null,"5",1]
[null,null,"800",1]
[null,null,"Englewood",1]
[null,null,"Drv",1]
[null,null,"Crawsfordsville",1]
[null,null,"2700",1]
[null,null,"Valley",1]
[null,null,"High",1]
[null,null,"NW",1]
[null,null,"Rochester",1]
[null,null,"MN",1]
[null,null,"813",1]
[null,null,"Bookman",1]
[null,null,"Pontiac",1]
[null,null,"SC",1]
[null,null,"1500",1]
[null,null,"Eastride",1]
[null,null,"Aven",1]
[null,null,"Riverside",1]
[null,null,"500",1]
[null,null,"North",1]
[null,null,"11801",1]
[null,null,"Chesterdale",1]
[null,null,"1034",1]
[null,null,"Depot",1]

{"sheet":"Custom delimiter","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Word frequency analysis with custom delimiter"]
["Comma-separated list",null,"Unique words","Count"]
["January,February,March,April",null,{"$f":"FreqWords(A3:A16, \",\")","v":"August"},6]
["March,April,May,June,July,August",null,"September",6]
["January,September,October,November",null,"October",6]
["February,March,December",null,"November",6]
["May,November,December",null,"December",6]
["April,May,October,November,December",null,"March",4]
["September,October,November,December",null,"April",4]
["July,August,September,October",null,"May",4]
["March,April,December",null,"July",4]
["August,September,December",null,"January",3]
["January,February,August,September",null,"February",3]
["September,October,November",null,"June",2]
["May,June,July,August"]
["July,August,October,November"]

{"sheet":"Within one cell","index":3,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Count text frequencies in one cell"]
["Comma-separated list"]
["January,February,March,April,March,April,\nMay,June,July,August,January,September,\nOctober,November,February,March,\nDecember,May,June,July,August,August,\nSeptember,December,August,September,\nDecember,July,August,October"]
[]
["Unique words","Count"]
[{"$f":"FreqWords(A3, \",\")","v":"August"},5]
["March",3]
["July",3]
["January",2]
["February",2]
["April",2]
["June",2]
["September",2]
["\nDecember",2]
["\nMay",1]
["\nOctober",1]
["November",1]
["May",1]
["\nSeptember",1]
["December",1]
["October",1]

{"sheet":"Compare frequencies","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Comprare word frequency in two lists"]
["List 1",null,"List 2",null,"List 1: Word Frequency ",null,null,"List 2: Word Frequency ",null,null,"Word","List 2","List 1","Compare frequencies"]
["Semisweet Chocolate",null,"Semisweet Chocolate",null,{"$f":"FreqWords(A3:A18)","v":"Chocolate"},16,null,{"$f":"FreqWords(C3:C18)","v":"Chocolate"},15,null,{"$f":"FreqWords(C3:C18)","v":"Chocolate"},15,{"$f":"_xlfn.XLOOKUP(K3, $E$3:$E$10, $F$3:$F$10, \"not found\")","v":16},{"$f":"IF(L3=M3, \"Match\", \"Don't match\")","v":"Don't match"}]
["Ruby Chocolate",null,"Chocolate Milk",null,"Semisweet",5,null,"Hazelnut",4,null,"Hazelnut",4,{"$f":"_xlfn.XLOOKUP(K4, $E$3:$E$10, $F$3:$F$10, \"not found\")","v":2},{"$f":"IF(L4=M4, \"Match\", \"Don't match\")","v":"Don't match"}]
["Chocolate ExtraDark ",null,"Unsweetened Chocolate",null,"ExtraDark",4,null,"Semisweet",3,null,"Semisweet",3,5,"Don't match"]
["White Chocolate",null,"Hazelnut Chocolate",null,"Hazelnut",2,null,"Milk",2,null,"Milk",2,2,"Match"]
["ExtraDark Chocolate",null,"ExtraDark Chocolate",null,"Milk",2,null,"ExtraDark",2,null,"ExtraDark",2,4,"Don't match"]
["Chocolate Hazelnut",null,"Chocolate ExtraDark",null,"Ruby",1,null,"Unsweetened",1,null,"Unsweetened",1,"not found","Don't match"]
["Chocolate Semisweet",null,"Dark Chocolate",null,"White",1,null,"Dark",1,null,"Dark",1,"not found","Don't match"]
["Hazelnut Chocolate",null,"Cocoa Powder",null,"Bittersweet",1,null,"Cocoa",1,null,"Cocoa",1,"not found","Don't match"]
["Chocolate Semisweet",null,"Chocolate Hazelnut",null,null,null,null,"Powder",1,null,"Powder",1,"not found","Don't match"]
["Bittersweet Chocolate",null,"Milk Chocolate",null,null,null,null,"Liquor",1,null,"Liquor",1,"not found","Don't match"]
["Milk Chocolate",null,"Hazelnut Chocolate",null,null,null,null,"White",1,null,"White",1,1,"Match"]
["ExtraDark Chocolate",null,"Chocolate Liquor"]
["Chocolate Milk ",null,"White Chocolate"]
["Semisweet Chocolate",null,"Chocolate Semisweet"]
["Chocolate Semisweet",null,"Hazelnut Chocolate"]
["ExtraDark Chocolate",null,"Semisweet Chocolate"]

{"sheet":"Compare frequencies 2","index":5,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,17,0],[2,2,17,2]]}
["Comprare word frequency in two cells"]
["List 1",null,"List 2",null,"List 1: Word Frequency ",null,null,"List 2: Word Frequency ",null,null,"Word","List 2","List 1","Compare frequencies"]
["Semisweet Chocolate,Ruby Chocolate,Chocolate ExtraDark ,White Chocolate,ExtraDark Chocolate,Chocolate Hazelnut,Chocolate Semisweet,Hazelnut Chocolate,Chocolate Semisweet,Bittersweet Chocolate,Milk Chocolate,ExtraDark Chocolate,Chocolate Milk,Semisweet Chocolate,Chocolate Semisweet,ExtraDark Chocolate",null,"Semisweet Chocolate,Chocolate Milk,Unsweetened Chocolate,Hazelnut Chocolate,ExtraDark Chocolate,Chocolate ExtraDark,Dark Chocolate,Cocoa Powder,Chocolate Hazelnut,Milk Chocolate,Hazelnut Chocolate,Chocolate Liquor,White Chocolate,Chocolate Semisweet,Hazelnut Chocolate,Semisweet Chocolate",null,{"$f":"FreqWords(A3,\",\")","v":"ExtraDark Chocolate"},3,null,{"$f":"FreqWords(C3,\",\")","v":"Hazelnut Chocolate"},3,null,{"$f":"FreqWords(C3,\",\")","v":"Hazelnut Chocolate"},3,{"$f":"_xlfn.XLOOKUP(K3, $E$3:$E$13, $F$3:$F$13, \"not found\")","v":1},{"$f":"IF(L3=M3, \"Match\", \"Don't match\")","v":"Don't match"}]
[null,null,null,null,"Chocolate Semisweet",3,null,"Semisweet Chocolate",2,null,"Semisweet Chocolate",2,{"$f":"_xlfn.XLOOKUP(K4, $E$3:$E$13, $F$3:$F$13, \"not found\")","v":2},{"$f":"IF(L4=M4, \"Match\", \"Don't match\")","v":"Match"}]
[null,null,null,null,"Semisweet Chocolate",2,null,"Chocolate Milk",1,null,"Chocolate Milk",1,1,"Match"]
[null,null,null,null,"Ruby Chocolate",1,null,"Unsweetened Chocolate",1,null,"Unsweetened Chocolate",1,"not found","Don't match"]
[null,null,null,null,"Chocolate ExtraDark ",1,null,"ExtraDark Chocolate",1,null,"ExtraDark Chocolate",1,3,"Don't match"]
[null,null,null,null,"White Chocolate",1,null,"Chocolate ExtraDark",1,null,"Chocolate ExtraDark",1,"not found","Don't match"]
[null,null,null,null,"Chocolate Hazelnut",1,null,"Dark Chocolate",1,null,"Dark Chocolate",1,"not found","Don't match"]
[null,null,null,null,"Hazelnut Chocolate",1,null,"Cocoa Powder",1,null,"Cocoa Powder",1,"not found","Don't match"]
[null,null,null,null,"Bittersweet Chocolate",1,null,"Chocolate Hazelnut",1,null,"Chocolate Hazelnut",1,1,"Match"]
[null,null,null,null,"Milk Chocolate",1,null,"Milk Chocolate",1,null,"Milk Chocolate",1,1,"Match"]
[null,null,null,null,"Chocolate Milk",1,null,"Chocolate Liquor",1,null,"Chocolate Liquor",1,"not found","Don't match"]
[null,null,null,null,null,null,null,"White Chocolate",1,null,"White Chocolate",1,1,"Match"]
[null,null,null,null,null,null,null,"Chocolate Semisweet",1,null,"Chocolate Semisweet",1,3,"Don't match"]