Thread: How do I find dups across different columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_106_] JBeaucaire[_106_] is offline
external usenet poster
  
Posts: 1
Default How do I find dups across different columns

To only get DUP when both the ID and the Name are duplicated TOGETHER
somewhere else, this would accomplish that:

=IF(SUMPRODUCT(--($F$1:$F$100=F1),--($A$1:$A$100=A1))1,"Dup","No Dup")


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57718

Reply With QuoteReply With Quote