前幾名出現字母取出 且相聚 (13667)

G2:H2下拉{=IFERROR(OFFSET(B$1,RIGHT(SMALL(IF(COUNTIF(OFFSET($B$2,,,ROW($1:$15)),$B$2:$B$16)<=$E$2,MATCH($B$2:$B$16,$B:$B,)/1%+ROW($1:$15)),ROW(A1)),2),),"")



留言