二數據 重複與否 一公式分別提取 (13998)

D2:E9{=INDIRECT(TEXT(MIN(IF(((COUNTIF($A:$B,$A$2:$B$9)>1)-($B$1=A$1))*(COUNTIF(D$1:D1,$A$2:$B$9)=0),ROW($2:$9)/1%+{1,2}),999),"!R0C00"),)&""



留言