Rank of 2 condition data sets

[NNOG28]

Below is the data set. I'd like to use the formula under the Rank column -- to rank by sales under the same Item#, and the same item # that has the same sales needs to have a different rank order.

Item #	Sales	Rank
101	8	2
101	6	3
101	6	4
101	10	1
102	2	4
102	6	1
102	3	3
102	5	2
103	25	4
103	35	3
103	60	1
103	55	2

<tbody>
</tbody>

Thank you.

 

[Marcelo Branco]

Try

Formula in C2 copied down
=COUNTIFS(A$2:A$13,A2,B$2:B$13,">"&B2)+COUNTIFS(A$2:A2,A2,B$2:B2,B2)

Hope this helps

M.

 

[NNOG28]

It works. Thank you so much. I would never think of this kind of formula for sure. Never see any A$2:A2 ...

Try

Formula in C2 copied down
=COUNTIFS(A$2:A$13,A2,B$2:B$13,">"&B2)+COUNTIFS(A$2:A2,A2,B$2:B2,B2)

Hope this helps

M.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.