Hi.
I would appreciate some help on getting a formula. I've searched and tested all I could find but all the examples do not achieve what I'm attempting. Here's the image of what I'm searching:
In other words, where I made a pivot table of this, I want to get
Top 20: 2 people
Medium: 10 people
Low 20: 6 people
Problem with any rank is the duplicates amounts. They get rank the same - or I'm not getting something. Thanks a lot
I would appreciate some help on getting a formula. I've searched and tested all I could find but all the examples do not achieve what I'm attempting. Here's the image of what I'm searching:

In other words, where I made a pivot table of this, I want to get
Top 20: 2 people
Medium: 10 people
Low 20: 6 people
Problem with any rank is the duplicates amounts. They get rank the same - or I'm not getting something. Thanks a lot