12 Replies Latest reply on Dec 21, 2009 4:20 PM by RCaauwe

    Summary count of duplicate numbers..

    RCaauwe

      Title

      Summary count of duplicate numbers..

      Post

      I have a layout report that shows a list of N Numbers.  Many of these are duplicates (which is normal).  They are sorted in N Number order, so the duplicates are together.  I want to know the total number of unique N Numbers there are.  In other words I want a count of the groups of N Numbers, not how many are in each group.

       

      Example:  If my list looked like this:

      N123

      N123

      N567

      N678

      N999

      N999

      N999

      The summary count I would want to see is:  4