Finding the highest Value/Score from columns

[Uk]

Hi All,

How to find the highest Score from these columns?

say, in this table , it has:

Score A = 80

Score B = 79

Score C = 80

Any idea what is the formula how to know the highest score form the column above? thanks

[Suvrutt_Gurjar · Accepted solution]

When computing within the same row, the columns will need to mentioned exclusively.

 MAX(LIST([Score A] ,  [Score B] ,  [Score C]))

will get the highest score.

[Uk]

Hi @Suvrutt_Gurjar  I have another problem.

How if I want to appear the column name of the highest score.

from this formula

 MAX(LIST([Score A] ,  [Score B] ,  [Score C]))

we only get the score. But How if the column  "The highest score" appears: Score A, Score C  ???

Because they both have the highest score.

Thank you again

[Uk]

This morning I tried the same formula, but didn't work.

But Nowww, from you, it works. You are really really a wizard @Suvrutt_Gurjar  😁 thank you so much

[Suvrutt_Gurjar]

I believe there is no easy way to make the "column by names" to appear for highest scores. AppSheet expressions work with column values and not column names.