同字母依順序相聚且顯單一 (14756)

G2{=SUBSTITUTE(INDEX(B:B,RIGHT(SMALL(MATCH(B$2:B$16,E:E,)/1%+ROW($2:$16),ROW(A1)),2)),LOOKUP(1,0/(G$1:G1<>""),G$1:G1),)

F2{=INDEX(C:C,SMALL(IF(LOOKUP(1,0/(G$2:G2<>""),G$2:G2)=B$2:B$16,ROW($2:$16)),LOOKUP(1,0/(G$2:G2<>""),ROW(A3)-ROW($2:2))))