排序 依出現次數 (15006)

E3:E16{=INDIRECT(TEXT(RIGHT(MAX(IF(COUNTIF(E$2:E2,A$3:C$16)=0,COUNTIF(A:C,A$3:C$16)/1%%+ROW($3:$16)/1%+{1,2,3})),4),"!R0C00"),)&""

F3:F16=IF(E3="","",COUNTIF(A:C,E3))



留言