Home > Blockchain >  Finding Unique 2 Word Pairs In Google Sheets And Then Counting The Frequency From A Range ("Phr
Finding Unique 2 Word Pairs In Google Sheets And Then Counting The Frequency From A Range ("Phr

Time:10-15

Please see: enter image description here


update:

=INDEX(LAMBDA(a, LAMBDA(x, QUERY(QUERY(x&" "&{QUERY(x, 
 "offset 1", ); ""}, "where not Col1 contains '×××'", ), 
 "select Col1,count(Col1) 
  where not Col1 matches '"&TEXTJOIN("|", 1, UNIQUE(LOWER(E2:E)))&"' 
  group by Col1 order by count(Col1) desc label count(Col1)''"))
 (FLATTEN(SPLIT(QUERY(FLATTEN({REGEXREPLACE(LOWER(a), "[\.,\?!\(\)]", ), 
 IFERROR(a/0, "×××")}),,9^9), " "))))(A1:A2))

enter image description here

  • Related