One designation for highest value - don't count duplicates

I am building an athlete testing database that will designate a given result as a "PR" (Personal Record) for the athlete if it is the best mark that they achieve on a given test. The issue I am running into is if they tie their Personal Record in multiple tests, it will designate those values as PR's as well. We are doing some analytics and would like to have this formula work to only count a PR once and then leave duplicate PR's as a blank value within the cell designation, so what formula would work to accomplish this?

As an aside, the worksheet I have uploaded is the values only- the actual formulas are linked to other workbooks and would obviously make it difficult to get this formula worked on, so I am looking for a formula to nest into a massive conditional formula that populates the "PR" designation. That formula is:

Formula:

Please Login or Register  to view this content.

The example athlete/test combination to filter out would be Athlete: "Mathis, Devin" and Test: "Max Output", where he achieved 32 as his result three times.

Originally Posted by Olly

In N2:

Formula:

Please Login or Register  to view this content.

You don't need your concatenated G and H columns, with this formula.

I do not have access to the MAXIFS and MINIFS formulas within my version of excel

Originally Posted by Olly

Your profile states Office 2016...

Attachment 645831

Unless it makes a difference that it is the professional version that I am licensed through the school I work at?