From: Kristin on 23 Apr 2010 08:50 Hello, I am trying to classify 5 columns of scores into groups based on the dominant score in each row. for example, if column A2 has the highest score out of A2:E2, then the classification number should be 1. likewise if E2 has the highest score out of A2:E2, then the classification number should be 5 any thoughts? From: Jacob Skaria on 23 Apr 2010 09:01 Do you mean =MAX(A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: > Hello, > > I am trying to classify 5 columns of scores into groups based on the > dominant score in each row. for example, if column A2 has the highest score > out of A2:E2, then the classification number should be 1. likewise if E2 has > the highest score out of A2:E2, then the classification number should be 5 > > any thoughts? From: Bernd P on 23 Apr 2010 09:10 > Do you mean> > =MAX(A2:E2) > Maybe more like =MATCH(MAX(A2:E2),A2:E2,0) I guess. Regards, Bernd From: Kristin on 23 Apr 2010 09:15 sort of, but i don't need the value of the max, i need the column that the max value is in... "Jacob Skaria" wrote: > Do you mean > > =MAX(A2:E2) > > -- > Jacob (MVP - Excel) > > > "Kristin" wrote: > > > Hello, > > > > I am trying to classify 5 columns of scores into groups based on the > > dominant score in each row. for example, if column A2 has the highest score > > out of A2:E2, then the classification number should be 1. likewise if E2 has > > the highest score out of A2:E2, then the classification number should be 5 > > > > any thoughts? From: Jacob Skaria on 23 Apr 2010 09:26 Try =MATCH(MAX(A2:E2),A2:E2) -- Jacob (MVP - Excel) "Kristin" wrote: > sort of, but i don't need the value of the max, i need the column that the > max value is in... > > "Jacob Skaria" wrote: > > > Do you mean > > > > =MAX(A2:E2) > > > > -- > > Jacob (MVP - Excel) > > > > > > "Kristin" wrote: > > > > > Hello, > > > > > > I am trying to classify 5 columns of scores into groups based on the > > > dominant score in each row. for example, if column A2 has the highest score > > > out of A2:E2, then the classification number should be 1. likewise if E2 has > > > the highest score out of A2:E2, then the classification number should be 5 > > > > > > any thoughts?  |  Next  |  Last