Rank 2 columns without Skipping Numbers

[hajiali]

X	Y	RANK
2	31	8
2	38	9
2	52	13
2	57	14
2	21	7
2	13	6
2	58	15
2	45	12
2	2	4
2	40	10
2	41	11
2	61	16
2	5	5
1	998	2
1	998	2
1	62	1

the code below is what I current have and above is the results.

=RANK(X3,$X$3:$X$401,1)+COUNTIFS($X$3:$X$401,X3,$Y$3:$Y$401,"<"&Y3)

I need the Results for the two in red need to be

1	998	2
1	998	3

using the above, if column A and B are manually imputed how would I rank the two columns in Rank Column. I would prefer a Non-Array formula and need it to Not Skip any numbers if there are Duplicate values.

 

[Fluff]

You can just add another countifs to the end of your formula
=RANK(X3,$X$3:$X$401,1)+COUNTIFS($X$3:$X$401,X3,$Y$3:$Y$401,"<"&Y3)+COUNTIFS($X$2:$X2,X3,$Y$2:$Y2,Y3)