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?