Macro Percentile Calculation for Ranks
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is the excel dummy I used for the Macro so far :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Managed to find a solution by myself. Let me know if somebody is interested!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
:raises hand: Please share your solution!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
