相同相聚 重複留空白 (10105)


C2{=IF(COUNTIF(C$1:C1,INDEX(B:B,RIGHT(SMALL(MATCH(B$2:B$16,B$2:B$16,)/1%+ROW($2:$16),ROW(A1)),2))),"",INDEX(B:B,RIGHT(SMALL(MATCH(B$2:B$16,B$2:B$16,)/1%+ROW($2:$16),ROW(A1)),2)))


留言