From: Kristin on 23 Apr 2010 09:51 almost...just not consistently correct... (last column contains the formula) 3 2 3.5 3.5 1.5 4 3.5 3 3.5 4 5 5 3.5 2 4.5 3 3.5 3 3 1 4.5 2 4 3 2 10 4.5 3.5 3 5 2 1.5 3.5 4 2.5 4 "Jacob Skaria" wrote: > 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? From: Kristin on 23 Apr 2010 10:04 That works!!!! Thank you both so much! "Bernd P" wrote: > > Do you mean > > > > =MAX(A2:E2) > > > > Maybe more like > =MATCH(MAX(A2:E2),A2:E2,0) > I guess. > > Regards, > Bernd > . > First  |  Prev  |