Classification
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?
|