Need a formula

[lynn]

I have 4 columns of data. The column headings are Mild,
Moderate, Severe, Maximal. The data is specifying
a 'reaction'. For instance, Row 2 (client 2) had 2 Mild, 6
Moderate, 2 Severe, and 1 Maximal.

I need a formula that will tell me that the highest number
appears in the Moderate column. Any ideas ?

 

[Dave R.]

You say "that the highest number appears in the Moderate column"

Do you mean the highest number that appears in the Moderate column? if so,

=MAX(A1:A500)

just plug in whatever row "Moderate" is.

if not, do you mean you want to return the heading for the column in which
the highest number appears?

 

[Ken Wright]

With your data in A22, in E2 put the following and copy down as far as you
need:-

=CHOOSE(MATCH(MAX(A22),A22,0),"Mild","Moderate","Severe","Maximal")