Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Short & Sweet
Took inspiration from others to try and solve this without the Multi-Row Formula Tool (nor the Group By feature in the more recent version of the Record ID tool). This challenge gets at the very useful difference between Row Numbering, Ranking, and Dense Ranking
Here's my solution:
Date: 2025.10.09
Designer: 2023.1
Nice! And many ways to solve it.