2 Replies Latest reply: Sep 27, 2018 12:05 PM by Andrey Krylov RSS

    Distinct ID Row Count

    Felix Dang

      Hi

       

      I would like to count the row count of the distinct value like the following table:

       

      ID    Count

      A     1

      A     2

      A     3
      A     4    

      B     1

      B     2

      B     3

      C     1    

      C     2
      C     3

      D     1

       

      I have googled abt RangeCount function but I don't think it can serve my purpose.

      Is there any method I can use for this calculation?

       

      Thanks

       

      Felix