Macro Percentile Calculation for Ranks

[ArminL]

Hey Community,

I'm having trouble integrating a percentile calculation in a macro.

Right now I get output telling me which row achieved which rank (see attached workflow!). What I need is another column that calculates me automatically the percentile ( example calculation: "1 - (Rank / Number of Ranks)" ). So if i have 10 rows, in the end the best row gets 100%, the second place 90%, third 80% etc...etc.etc...

I hope I could somehow explain my troubles. Any one out there who could help me out?

Thanks in advance and cheers!

Armin

[ArminL]

This is the excel dummy I used for the Macro so far :)

[ArminL · Accepted solution]

Managed to find a solution by myself. Let me know if somebody is interested!

[djoyus1]

:raises hand: Please share your solution!

[ArminL]

I attached the sample Macro I used to solve this problem. Maybe you can check out, whether you understand all the steps and maybe try some re-engineering.

Feel free to ask if you have any specific questions :)