2 Replies Latest reply on Aug 6, 2012 1:31 AM by BENOIT LEGRAND

    Find similar columns on unsorted array ?

    BENOIT LEGRAND

      Hello,

       

      Is it possible to do this?

       

      Column 1Column 2Value 1Value 2
      A1B110000
      A2B220001
      A3B330000
      A4B240001
      A5B450000

       

      - My table is sorted on the first column

      - I would like to identify in a calculated field (value 2) identical columns. 0 = the column is unique, 1 = the column is not unique.

       

      Thank you for the help.