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