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.
VBA Code:
=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.