重複次數指定內 全取 (14536)

G2:H16{=INDEX(B:B,SMALL(IF(COUNTIF(OFFSET($C$2,,,ROW($1:$15)),$C$2:$C$16)<=$E$2,ROW($2:$16),99),ROW(A1)))&""

B2:C16格式化=COUNTIF($C$2:$C2,$C2)>$E$2