排序 出現次數優先 數字由小至大 (10390)

 

 D8:I8{=IFERROR(100-MOD(LARGE(IF(COUNTIF($C8:C8,$D4:$F6)=0,COUNTIF($D4:$F6,$D4:$F6)/1%-$D4:$F6,""),1),100),"")