2 Replies Latest reply: Feb 24, 2017 4:04 AM by Andrey Khoronenko RSS

    Count Phrase in List

    Markus Mainiero

      Hi, I would like to count the appearance of a word in a List of Sentences.


      List:


      Number     Phrase

      1                Hello World

      2                Qapla

      3                the force awakens

      4                the force may be with you

      5                The Storm


      Now I want to count for example “force” or “the”.


      Force should be (2) and the (3)

       

      I have tried

       

      =SubStringCount(PHRASE,'force')

      =count({<PHRASE={'force'}>}Number)