排序 二種名稱 (12350)

G2:J10{=INDEX(B:B,RIGHT(SMALL(MMULT(1-ISERR(FIND(TRANSPOSE($L$2:$L$6),$B$2:$B$10)),ROW($1:$5)*2-1)*10^10+MMULT(1-ISERR(FIND({"甲","乙","丙","丁"},$B$2:$B$10)),{1;2;3;4})/1%+ROW($2:$10),ROW(A1)),2))