Hello Everyone,
I have below column Number. I want to rank those numbers according to their sequence. i.e. for max value rank should be 1 and lower value rank should be max.
In below table for number 28 we assigned the rank 1 and for 4 rank is 7. I calculated this rank in excel using Rank formula "RANK(A2,$A$2:$A$8)".
Is there any formula in Alteryx which can give me the same result.
Here number 28 is twice so Rank function applied same rank for both i.e. 1 and skipped rank 2.
If there is 28 three times then Rank function applied same rank for three same entries and skipped 2 and 3.
| Number | Rank |
| 10 | 6 |
| 23 | 4 |
| 25 | 3 |
| 28 | 1 |
| 4 | 7 |
| 28 | 1 |
| 11 | 5 |
Thank you in advance.
