9 Replies Latest reply: May 9, 2017 1:52 AM by Agrim Sharma RSS

    Compare Match

    Agrim Sharma

      Hi,

       

      I have two columns

      Name

      Name2

      Agrim

      agRim

      Laxman

      laxman

      abc

      Abc

      bac

      BAC

      dEf

      Def

       

       

       

       

      I want to compare Name and Name2

      & want output as “Yes” if all value of Name exist in Name2 and

       

      “No” if all value of Name does not exist in Name2

      And list of values that does not exist mutually in Name and Name2

       

      Thanks,