• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Repeated word count in sentence

Areif

New Member
Hello all !!

Hope all are safe and doing well , i got stuck at finding the repeated words in sentence.
hope here i get the solution... reference sheet is attached

Thanks in advanced
 

Attachments

  • Chandoo.xlsx
    8.4 KB · Views: 8
Thanks for reply , but getting #NAME? error, please suggest solution.
I think your excel version do not have TEXTJOIN function.

Then, try this helper columns ways,

1] In "Helper" E3, formula copied right until blank :

=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE(LOWER($B3),".","")," ","</b><b>")&"</b></a>","//b[preceding::* =.][not(following::* =.)]["&COLUMN(A1)&"]"),"")

2] In "Result" D3, enter formula :

=TRIM(E3&" "&F3&" "&G3&" "&H3&" "&I3&" "&J3&" "&K3&" "&L3&" "&M3&" "&N3&" "&O3&" "&P3)

76665
 

Attachments

  • ExtractRepeatedWord.xlsx
    11.9 KB · Views: 5
Back
Top