Prev: Start of macro via desktop icon no longer work
Next: Formula to format selective part in a text
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
Pages: 1 2
Prev: Start of macro via desktop icon no longer work
Next: Formula to format selective part in a text