5 Replies Latest reply: Mar 22, 2012 4:53 AM by Robert Svebeck RSS

    List of duplicates

    Robert Svebeck

      Hello

      I the following list  of data:

      F1 F2
      101 A
      101 C
      102 A
      103 A
      104 A
      201 B
      202 B
      203 B
      204 B
      301 C
      302 C
      303 C
      304 C


      As you can see; where F1=101 F2 exits twice :  for F2=A and F2=C


      My question is: How can I produce this list:

      F2
      A
      C

      For some reason (this seems to be a simple task) but I can just not get it to work ....

       

      I do not want a list like this (already have it...):

       

      F1 F2 COUNT(TOTAL <F1>  F1)
      101 A 2
      102 A 1
      103 A 1
      104 A 1
      201 B 1
      202 B 1
      203 B 1
      204 B 1
      101 C 2
      301 C 1
      302 C 1
      303 C 1
      304 C 1

      -> I just want a list of values on F2 where my count is greater than 1.


      //Robert