5 Replies Latest reply on Aug 29, 2018 6:28 AM by Okechukwu Ossai

    Row-level calculation indicating column with the highest value

    Konrad Zdeb

      Given the table below, I would like to introduce new column with row-level calculation idicating name of column that highest value for that particlar observation. In the case of this data, this would be the second column named B.

       

       

      Results for that specific row should correspond to the table below

      ObservationA
      B
      C
      D
      E
      F
      Max Value Column (new column)
      V907e3097118107357127851386846526B

       

      Workbook with the sample data is attached below.