ranking question

[pat67]

Hi. I am trying to rank some data as follows:

by total by group then the rest

examples

John East 150
Bill East 125
Steve South 170
Bob East 100
Jim West 120
Joe West 110
Mike South 105

I want to rank like this

1 Steve South 170
2 John East 150
3 Jim West 120
4 Bill East 125
5 Joe West 110
6 Mike South 105
7 Bob East 100

Any ideas? i can rank by overall, but I want to do by the top in each
area then the rest

Thanks

 

[Jim Cone]

With the data in A2:A8...
In B2 and fill down... =VALUE(RIGHT(A2,3))
In C2 and fill down... =RANK(B2,$B$2:$B$8,1)
'---
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
Special Sort Excel add-in (30 ways to sort)






"pat67" <[email protected]>
wrote in message
news:09374df4-18fd-419d-a8d6-e5477ff8141c@k14g2000vbe.googlegroups.com...

 

[pat67]

With the data in A2:A8...
In B2 and fill down... =VALUE(RIGHT(A2,3))
In C2 and fill down... =RANK(B2,$B$2:$B$8,1)
'---
Jim Cone
Portland, Oregon USA  .http://www.mediafire.com/PrimitiveSoftware .
Special Sort Excel add-in (30 ways to sort)

"pat67" <[email protected]>
wrote in message








- Show quoted text -

that's just giving me an overall rank.