Help with ranking based on criteria (RANKEQ, COLLECT)
I am trying to rank location names by the number of activities they've accomplished within their specific region.
When I searched the forum, I found a few examples of RANKEQ with COLLECT. However, I receive errors when I insert this:
=RANKEQ([Total Activities]@row, COLLECT([Total Activities]:[Total Activities], Region:Region, "Gulf Coast", 0))
Can you point me in the right direction? Thank you!
Help Article Resources
Check out the Formula Handbook template!