Thread: Duplicates
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Andy Daugherty Andy Daugherty is offline
external usenet poster
  
Posts: 7
Default Duplicates
Ok, one last question.
Everything works great for Sheet1, but I have Sheet2 and Sheet3 also.
I'm not sure where to place the Sheet numbers.

=SUMPRODUCT(--($C$1:$C$50&G$1:$G$50=C1&G1))=1
Reply With QuoteReply With Quote