1 Reply Latest reply on Aug 3, 2012 9:14 AM by Tracy Rodgers

    Identifying, displaying & quantifying like terms in a data set

    Erik Ford

      The goal is to return matches of phrases (more than 2 of the same word I guess) by each of these rows, with what the phrase is and how many instances it occurs.

       

      For example:

      Google Ad 1

      8-1-2012 4-56-08 PM.png

      Google Ad 2

      8-1-2012 4-56-08 PM.png

       

      and the Descr Line 1 has 3 of the same words, then:

       

       

      Instances

      Clicks

      Spend

      Be Found In

      15

      500

      $500

      More Online Searches

      20

      450

      $750