5 Replies Latest reply: Oct 21, 2016 2:43 AM by jagan mohan rao appala RSS

    Distinct Count of two columns


      I have two columns that have the Employee IDs.


      I want to get these three values:

      1. Distinct Employees in Column 1

      2. Distinct Employees in Column 2

      3. Distinct Employees that appear in both columns


      The first two are straightforward but I'm struggling with the last scenario.


      Please help