Duplicate Alert Formula

Hello Experts,

I could use your help.  See attached sample file.  I want a formula in cell A2 to display "DUPLICATE" when a duplicate appears in column C?

Thanks,

Gary
Cincinnati
012513Tel-EE-Dup-Check-1-31-13.xlsx
garyrobbinsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
Try:

=IF(COUNTA(C6:C35)>SUMPRODUCT((C6:C35<>"")/COUNTIF(C6:C35,C6:C35&"")),"DUPLICATES","")
0
 
NBVCCommented:
Try:

=IF(SUM(IF(C6:C35<>"",IF(1/COUNTIF(C6:C35,C6:C35)<1,(1/COUNTIF(C6:C35,C6:C35))))),"DUPLICATE","")

confirmed with CTRL+SHIFT+ENTER not just ENTER
0
 
garyrobbinsAuthor Commented:
Thanks, NB_VC.

Is there an alternate way of writing this formula that does not require the confirmation {}?

Gary
0
 
garyrobbinsAuthor Commented:
Yes!  I love that "SumProduct" formula...

I appreciate the prompt response also.   Good job.

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.