11 Replies Latest reply on Sep 29, 2016 10:40 AM by kettan

    Comparing rows in same column

    Abhinav Kumar

      Hi Everyone,

       

      I am facing an issue which data comparison in same row. Adding a sample data set.

        

      S.No.First NameTitleEmail
      1DaveDirectordave.d@abc.com
      2DaveManagerdave.m@abc.com
      3JonDirectorjon.d@abc.com
      4JonVPjon.v@abc.com
      5JonDirectorjond@abc.com
      6DaveManagerdavemm@abc.com
      7JonVPjonnnv@abc.com
      8AliceCEOalice.c@abc.com

      In this data set, I want to identify and display all those rows which have same Name and Title but different email address. For example row 5 has the same name and title as row 3 but different email address. Similarly row 6 for 2 and row 7 for 4. In the end, I have to display as tabular format showing which all  names with titles have different email addresses.

      Please help me out.


      Thanks,A