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