1 Reply Latest reply on Aug 25, 2016 3:35 PM by Shinichiro Murakami

    How do I count the number of times a value is repeated in rows (A LOT OF VALUES) ?

    Pedro Ribeiro

      Hi guys,

       

      To ilustrate my question:

       

      Values

      A

      A
      B
      B
      B
      C
      C

       

      What I want is this:

       

      How many times it's repeatedNumber of Values

      1

      0
      22
      31

       

      How to read the table:

       

      • There are none values with no repetitions
      • There are 2 values whitch repeat two times
      • There is one value whitch repeat one time

       

      PS: This count will happen in a table with a lot of values (2MM+ with 1MM+ distinct)

       

      Thanks!