Prev: Modify Keyboard Shortcuts? Excel 2007
Next: All colors in Office documents are grayscale, how do I see colors
From: מיכאל (מיקי) אבידן on 1 Feb 2010 15:43
Chapeau !!!
Micky


"Luke M" wrote:

> Assuming Manager name is in column B and are grouped together, score in
> column C...
> In D2:
> =RANK(C2,OFFSET(INDEX(Sheet1!$C:$C,MATCH(Sheet1!$B2,Sheet1!$B:$B,0)),,,COUNTIF(Sheet1!$B:$B,Sheet1!$B2)))
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "dchristo" wrote:
>
> > I need to figure out how to rank by manager ex:
> >
> > Processor Manager Score Rank
> > Albert Scott 80.9 2
> > Brian Scott 91.5 1
> > Cathy Scott 79.3 3
> > Mable Delores 99.9 1
> > Elaine Delores 95.6 2
> > Tony Delores 73.5 3
> >
> > I have 100 or so managers so I want a formula to calculate it automatically
> > without any manual intervention.
> >
> > Thanks
From: T. Valko on 1 Feb 2010 17:13
Try this...

Entered in D2 and copied down as needed.

=SUMPRODUCT(--(B$2:B$7=B2),--(C2<C$2:C$7))+1

--
Biff
Microsoft Excel MVP


"dchristo" <dchristo(a)discussions.microsoft.com> wrote in message
news:7776CAFF-574D-42B7-B2E2-C1DD27F935D1(a)microsoft.com...
>I need to figure out how to rank by manager ex:
>
> Processor Manager Score Rank
> Albert Scott 80.9 2
> Brian Scott 91.5 1
> Cathy Scott 79.3 3
> Mable Delores 99.9 1
> Elaine Delores 95.6 2
> Tony Delores 73.5 3
>
> I have 100 or so managers so I want a formula to calculate it
> automatically
> without any manual intervention.
>
> Thanks


First  |  Prev  | 
Pages: 1 2
Prev: Modify Keyboard Shortcuts? Excel 2007
Next: All colors in Office documents are grayscale, how do I see colors