Classification
 

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?

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?

Classification
 

Do you mean

=MAX(A2:E2)


Maybe more like
=MATCH(MAX(A2:E2),A2:E2,0)
I guess.

Regards,
Bernd

Classification
 

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?

Classification
 

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?

Classification
 

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?

Classification
 

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
.