Solved

Duplicate Alert Formula

Posted on 2013-01-31
4
220 Views
Last Modified: 2013-02-01
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
0
Comment
Question by:garyrobbins
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 38840580
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
 

Author Comment

by:garyrobbins
ID: 38840646
Thanks, NB_VC.

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

Gary
0
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 38840687
Try:

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

Author Closing Comment

by:garyrobbins
ID: 38840908
Yes!  I love that "SumProduct" formula...

I appreciate the prompt response also.   Good job.

Gary
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question