locked
Calculated Column return column name and value RRS feed

  • General discussion

  • Hi, from SharePoint List,

    How can I get column name of the Max value?

    e.g: =MAX(VALUE([Raw FCS]),VALUE([Raw ECS]),VALUE([Raw LCS]),VALUE([Raw PCS]),VALUE([Raw RCS]))*VALUE([Raw Likelihood Score]) return the Max Value of these 5 value.

    How to get the column name of the this value?

    kind regards

    Sunday, May 28, 2017 2:40 PM

All replies

  • Sorry

    this is the exemple: =MAX(VALUE([col1]),VALUE([col2]),VALUE([col3]),VALUE([col4]),VALUE([col15])).

    I need the the formula which return Col1 or Col2. the which which get the max value.

    Thank you for your help

    Monday, May 29, 2017 8:23 AM