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