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.
I went as far as possible but i want this:
criteria
if remove gender and fill code ranked by code and number
if remove code and fill gender ranked by gender and number
if fill both ranked by code & gender and number
if both is empty ranked by just number Now whatever is gender & code
I want the formula to work either without condition or with one condition or with two conditions