2 Replies Latest reply on Aug 15, 2018 5:46 PM by Okechukwu Ossai

    returning a relevant discrete data

    Daoyi Cheng

      Hi, I met a problem for returning relevant discrete data.


      The first column is for counting how many data.

      The second column is for counting the maximun repeat data.

      I need to know that what the maximun repeat data is.



      for example:

      A     kevin

      A     kevin

      11     mic

      11     mic

      11     mic

      1     mar



      so, I got the first result is 6 (6 rows).

      then i got the second result is 3 (3 times repeat)

      but how can i know the "3" is for "mic"?


      does anyone can help?


      Thank you for your time!