Ranking in Alteryx

[alt_tush]

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.

[JosephSerpis · Accepted solution]

Hi @alt_tush I mocked up an approach which produces the output you describe let me know what you think?

[alt_tush]

Hi JosephSerpis,

Thank you for your quick response 🙂

Yes i have also the same approach but i am looking for some alternative or functions which can give me the output by using these sorting multirow or recordID tool.

Thanks again. This is useful and it has resolved my issue,