二欄不重複 且同名相聚 (15167)

D3:E10{=INDEX(A:A,RIGHT(MIN(IF(COUNTIFS($D$2:$D2,$A$3:$A$11,$E$2:$E2,$B$3:$B$11)=0,MATCH($A$3:$A$11,$A$3:$A$11,)/1%+ROW($3:$11),9999)),2))&""



留言