判斷二列 有與無 提列 (12165)

I3{=IF(A3="",INDEX(E:E,SMALL(IF(COUNTIF(A$3:A$17,E$3:E$17),99,ROW($3:$17)),COUNTIF(A$3:A3,"")))&"",IF(COUNTIF(E$3:E$17,A3),A3,""))



留言