三欄取唯一值 有二欄合併格 (13725)

F2:H13{=IFERROR(INDEX(LOOKUP(ROW(2:15),ROW(2:15)/(B$2:B$15<>""),B$2:B$15),SMALL(IF(MATCH($B$2:$B$15&LOOKUP(ROW(2:15),ROW(2:15)/($C$2:$C$15<>""),$C$2:$C$15)&LOOKUP(ROW(2:15),ROW(2:15)/($D$2:$D$15<>""),$D$2:$D$15),$B$2:$B$15&LOOKUP(ROW(2:15),ROW(2:15)/($C$2:$C$15<>""),$C$2:$C$15)&LOOKUP(ROW(2:15),ROW(2:15)/($D$2:$D$15<>""),$D$2:$D$15),)=ROW($1:$14),ROW($1:$14)),ROW(A1))),"")