5 Replies Latest reply on May 11, 2017 12:58 AM by Zhouyi Zhang

    Finding duplicate values using combined columns

    Abhinav Kumar

      Hi All,

       

      I have four columns having Name1, Id1, Name2 and Id2 and I want to identify all those cells where the combination of Name and Id are similar. For ex:

       

        

      Name 1Id 1Name 2Id 2
      Peterp123Dianad123
      Alexa123Gweng123
      Dianad123Peterp333
      Philp223Philp223
      Gweng123Steves223
      Alexa223Alexa223
      Steves123
      Billb123
      Bobb223

       

      In this sample data, the output should give me everything from Name2, Id2 except Peter with id p333.

      I wrote a calculated field for this but it is only giving me the output where individual rows have similar values. I am attaching the sheet for reference.

       

      Any help is much appreciated!

       

      Thanks!