Hi, Please help to find duplicate data. Attaching excel for reference. Thanks in advance.
P premjeetgupta Member Jul 24, 2017 #1 Hi, Please help to find duplicate data. Attaching excel for reference. Thanks in advance. Attachments Find Duplicate.xlsx 9.8 KB · Views: 15
AliGW Active Member Jul 24, 2017 #2 Try this: =CHOOSE(COUNTIFS($B$5:$B5,B5,$C$5:$C5,C5)+COUNTIFS($B$5:$B5,C5,$C$5:$C5,B5),"OK","Duplicate")
Try this: =CHOOSE(COUNTIFS($B$5:$B5,B5,$C$5:$C5,C5)+COUNTIFS($B$5:$B5,C5,$C$5:$C5,B5),"OK","Duplicate")
B bosco_yip Excel Ninja Jul 24, 2017 #5 Maybe..... =IF(COUNTIF(C$5:C5,B5)+COUNTIF(B$5:B5,C5),"Duplicate","OK") Regards Bosco