出現順序 緊接顯對應 (10797)

F2{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(D$2:D$7=TRANSPOSE(A$1:A$6),COLUMN(A:F)+ROW(1:6)/1%),ROW(A1)),2)),"")