有重複 於最後出現處取資料 (12547)

D2=IF(COUNTIFS(A:A,A2,B:B,B2,C:C,C2)=COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2),TEXT(LOOKUP(1,0/(G$2:G$8=A2)/(H$2:H$8=B2)/(I$2:I$8=C2),J$2:J$8),"YY/MM/DD;;"),"")