C2=IF(COUNTIFS($A$2:$A$39947,$A2,$B$2:$B$39947,$B2)=1,"No duplicates","Have Duplicates")
Try this and copy towards down
C2=IF(COUNTIFS($A$2:$A$39947,$A2,$B$2:$B$39947,$B2)=1,"No duplicates","Have Duplicates")
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks