RANKING

[razzy]

Hi all,

I am trying to create a rank for every unique identifier score, using the multi formula tool but even though i think my configuration may be correct i am not getting the desired output as i described. 

for instance between records 1-20;   2.7 should be ranked 1, followed by the next in order of magnitude 2 etc .

Can someone help me with this please 

attached is the workbook

and a screen shot multi formula tool.

[AndrewS]

Hi @razzy 

You could use a Tile tool, I've attached sample as I could not access your attachment.

[fmvizcaino · Accepted solution]

Hi @razzy ,

If I understood right your problem, you only missed a sort tool in your workflow as attached workflow.

Let me know if that works for you.

Best,

Fernando V.

[razzy]

Thank you both