using Large() and Max() without replacement from a list

Hi

Have a look on attachment.

Is this what you looking?

Here is a beginning of solution for the top overall and the top by center.
Still working on the top by region which is more complicated for me though.
It uses the original data from column A to G

This looks like it works. Some challenges there with special cases. For instance, king wins stg should he still be listed as winner in stg natnl since he's the only one there?

I ended up with two sheets with slightly different formulas, I hope one of them is alright.

Version 2 main formula looks like this:

Formula:

Please Login or Register  to view this content.

These are array formulas and need to be entered with Ctrl+Shift+Enter.

Here is I think) a final and complete solution to your problem.
Sometimes, there is not enough data so the LARGE function return a #NUM value.
As previously, all formula work with original data at column A to G
Regards

Good efforts by micope21 and p24leclerc but using full columns with array formulas is maybe a little too brave. I got the impression that my laptop really struggled with the recalc.
Just replace the full columns in the formulas with an adequate range and it will be fine.