M
MNF
I m using Excel 2002. My data looks like this:
a b c d
1 yellow Green Brown pink
2 16 12 14 15
I have used =max and =large formuli in another sheet (same workbook) to
display data in ascending order in a different table.
I also want to 'label' the data but can't work it out i.e. labelling 16
'yellow' using/adapting the above formuli. Also, in a seperate cell I have
looked at/tried: =If(a2>b2,"yellow",if(a2>c2,"yellow",if(a2>d2,"yellow")))
Which works fine provided yellow is always the greatest value but get an
error when I include the other columns in the same formula i.e. after
if(a2>d2,"yellow",if(b12>a2,"green" etc etc.
Can anyone help resolve this? Thanks.
a b c d
1 yellow Green Brown pink
2 16 12 14 15
I have used =max and =large formuli in another sheet (same workbook) to
display data in ascending order in a different table.
I also want to 'label' the data but can't work it out i.e. labelling 16
'yellow' using/adapting the above formuli. Also, in a seperate cell I have
looked at/tried: =If(a2>b2,"yellow",if(a2>c2,"yellow",if(a2>d2,"yellow")))
Which works fine provided yellow is always the greatest value but get an
error when I include the other columns in the same formula i.e. after
if(a2>d2,"yellow",if(b12>a2,"green" etc etc.
Can anyone help resolve this? Thanks.