Rank the list of numbers.

[iamviraj13]

Hi Everyone,

I need help in ranking the list of numbers. I have already sorted it in descending order and I need a rank in the following format:

I tried using record tool and it gave me output as 1,1,2,3,4,4,5. But instead, I want 1,1,3,4,5,5,7 similar to the format as above.

Any help would be appreciated. I have attached a file to use. Thanks.

 

[JosephSerpis · Accepted solution]

Hi @iamviraj13 I mocked up a workflow let me know what you think?

[BrandonB · Accepted solution]

I was able to accomplish this with a Record ID and a Multi-Row tool

 

[iamviraj13]

Thanks @JosephSerpis 

This worked.

[iamviraj13]

Thanks @BrandonB