均價 最高前幾名 (11399)

 E3{=IF(COUNTIF(B$3:B3,B3)>1,"",AVERAGE(LARGE(IF(B$3:B$17=B3,D$3:D$17),ROW(INDIRECT("1:"&MIN(COUNTIF(B:B,B3),G$3))))))



留言