Had the impression the Sumproduct() formula could be a solution ...
Would you mind sharing your workbook ...
I will try to help you out ... to the extent of my possibilities ...:wink:
Cheers
=MIN(IF($B$27:$B$46>0,$B$27:$B$46))/A14
=IF(AND(A14<>0,A14<>""),MIN(IF(OFFSET($A$27:$A$46,0,ROWS($1:1))>0,OFFSET($A$27:$A$46,0,ROWS($1:1))))/A14,"")
=IF(AND(A14<>0,A14<>""),MIN(IF(OFFSET($A$27:$A$46,0,ROWS($1:1))>0,OFFSET($A$27:$A$46,0,ROWS($1:1))))/A14,"")
=IFERROR(PERCENTRANK.INC($K$27:$K$42,$A$20,3),"")