Excel 2021 - Need modification of formula for dynamic TOP 10 table (repost)

Hello to everyone, this is a reposting of an older thread of mine (as it seems everyone lost their interest on it).

I apologize for my bad English in advance.

In the following excel sheet there is a dynamic database in the left panel (getting updates all the time), which consists of 3 main columns: NAMES, POSITIONS, STATS. My goal is to create a dynamic TOP 10 table of this database according to biggest values possible of STATS column, with these 2 criteria be necessary fullfilled:
a) Only distinct-unique values from Column A (so as NAMES in TOP 10 table will be different-no duplicates)
b) Be able to use values of Column B 100% at will (let's say in example I want only to use 1 "LB"-2 "CB"-1 "RB"-2 "CDM"-1 "LM"-1 "RM"-2 "ST" to create my list).
H09-22 (4).xlsx

Fellow member of this forum wk9128, kudos for the time he devoted on my previous thread, created a formula

Originally Posted by wk9128

post#14

Cell H3 formula , Drag down and across

Formula:

Please Login or Register  to view this content.

that almost managed to accomplish it, except for one thing. The results of it look like this (criterion b set as mentioned above):
Screenshot_2.png

The thing is, although all conditions are matched, criterion b isn't fully applied. The TOP 10 table maybe is indeed consisted of the AVAILABLE values set, but my purpose is to make use of ABSOLUTELY and EXACTLY these 10 POSITIONS (I repeat them again: 1 "LB"-2 "CB"-1 "RB"-2 "CDM"-1 "LM"-1 "RM"-2 "ST") 100% as desired. In other words in addition to other conditions set in the following excel sheet I'm looking for a result like this:
Screenshot_3.png

Please note that I don't mind to use helper columns or the order of TOP 10 table POSITIONS values to be the same.
Thanks a lot for your time in advance!

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread