Need a formula

  • Thread starter Thread starter lynn
  • Start date Start date
L

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 ?
 
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?
 
With your data in A2:D2, in E2 put the following and copy down as far as you
need:-

=CHOOSE(MATCH(MAX(A2:D2),A2:D2,0),"Mild","Moderate","Severe","Maximal")
 
Back
Top