Stack Ranking

[DSL1970]

I have a problem and have tried a couple of things, without any luck. Does anyone have any solutions.... I have 3 Sales guys, A, B, and C and they have all made sales and by Sales guy I want to stack rank their sales (highest =1 to lowest= X):

Sales Guy Sales Stack Rank
A $10,000 1, 2, 3, 4 or 5
A $11,000 1, 2, 3, 4 or 5
A $15,000 1, 2, 3, 4 or 5
A $13,000 1, 2, 3, 4 or 5
A $12,000 1, 2, 3, 4 or 5
B $10,000 1 or 2
B $11,000 1 or 2
C $13,000 1, 2, 3 or 4
C $12,000 1, 2, 3 or 4
C $14,000 1, 2, 3 or 4
C $15,000 1, 2, 3 or 4


Thank you!

 

[Marcelo Branco]

Try this formula

C2
=COUNTIFS(A:A,A2,B:B,">"&B2)+1
copy down

Hope this helps

M.

 

[DSL1970]

Perfect - Thank you!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.