15 Replies Latest reply: Sep 17, 2014 4:00 AM by Manish Kachhia RSS

    Assign row no

    Aidan O Reilly

      Hi there,

       

      If I had a table of data like the below, is it possible to have 3 column generated where by it increments by 1 each time the record in A is found?

       

      So A can occur one or more times but B is unique.

       

      Hope this makes sens.

       

      Thanks

      Aidan

       

       

      A               B               C

      test1         apple          1

      test1         orange        2

      test2         apple          1

      test3         apple          1

      test3         pear            2