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

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"
wrote in message
...
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

On Mar 24, 12:48*pm, "Jim Cone" wrote:
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"
wrote in ...



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- Hide quoted text -

- Show quoted text -

that's just giving me an overall rank.