3 Replies Latest reply: Feb 6, 2018 4:04 AM by Toni Kautto RSS

    How to count exceptions in columns based on another column

    Pascal Schwegler

      Hi Community,

       

      I have got two columns:

      Complexnr ; Year of construction

      3001 ; 1990

      3002 ; 1993

      3001 ; 1990

      3003 ; 1995

      3005 ; 2000

      3001 ; 1991

      3008 ; 2005

      3001 ; 1990

      3002 ; 1993

      3003 ; 1995

      3009 ; 2007

      etc.

       

      I would like to count rows of different construction year when Complexnr is the same.

      In my example: complexnr has 2 different Years of construction.


      Could anybody help me? Thanks in advance!

      Grtz. Pascal