字母順序 且同字母相聚 (12977)

G2:H2下拉 {=OFFSET($B$1,RIGHT(SMALL(IFERROR(MATCH($B$2:$B$99,$E$2:$E$20,),20)/1%%+MATCH($B$2:$B$99&"",$B$2:$B$99&"",)/1%+ROW($1:$98),ROW(A1)),2),B$2=$B$2)&""