8 Replies Latest reply on May 3, 2018 12:01 PM by William Brown

    Counting entries in a column one time if there are multiple entries

    William Brown

      I have a data import where I want to count the items in it one time, if they have an identical value in another column

       

      In my example you see that Widget A is there twice with the reference 1 and also reference 2.  I just want to count Widget A once.  How might I achieve this?

       

      Item
      Reference ID

      Widget A

      1

      Widget A

      1
      Widget B1
      Widget C1
      Widget A2
      Widget A2
      Widget B2
      Widget D2
      Widget A3
      Widget C3
      Widget B3