RANKING

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.

RANKING.xls

Common Use Cases

Accepted answers

fmvizcaino

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.

Ranking.yxmd

All comments

AndrewS

Hi @razzy

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

Rank.yxmd

fmvizcaino

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.

Ranking.yxmd

razzy

Thank you both

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703