This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
This challenge seemed so simple at first, but once I started it became clear I needed more tools than I thought I would. The worst part was you could literally see the top 5 but figuring out how to show them correctly was a challenge.
Process: 1. Renamed the value column and converted it to double. 2. Sorted the file by the descending order of the score 3. Used a multi-row formula with a conditional value to assign a rank based on the Score value. 4. Used a filter to limit the output to only the top 5 rankings