排序且取不重複值 (11102)

E2{=IFERROR(SMALL(IF(COUNTIF(E$1:E1,B$2:B$16)=0,B$2:B$16),1),"")

F2=IFERROR(VLOOKUP(E2,B:C,2,),"")

一式公式 H2:I12{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(MATCH($B$2:$B$16,$B$2:$B$16,)=ROW($1:$15),$B$2:$B$16/1%+ROW($2:$16)),ROW(A1)),2)),"")