rank desired number of large value without duplicate in other table

Hello, I have tried different ways but I could not solve this problem
I have searched a lot on the internet, but it still didn't work
I ask my friends to solve this for me
I want to find the top example 30 items without duplicate data from column H and insert them into the table shown
The desired number is entered in the yellow cell
The only important point here is that at the end of each column there is an H number that should not be included in the calculations
h38 h71 h93 and etc.