test for existance of non-blank duplicates

[West Man]

What formula (without helper cells) could I use to test for existance of non-blank duplicates in a range of cells containing text. I need only to know if duplicates exist, the number or location of duplicates is not of consequence.

 

[Aladin Akyurek]

What formula (without helper cells) could I use to test for existance of non-blank duplicates in a range of cells containing text. I need only to know if duplicates exist, the number or location of duplicates is not of consequence.

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(A2:A10<>"",MATCH("~"&A2:A10,A2:A10&"",0)),
    ROW(A2:A10)-ROW(A2)+1)>1,1))

Legend: A result of 0 means No Dups, a result greater than zero Dups Exist.

Constrol+shift+enter, not just enter:

=LOOKUP(SUM(IF(FREQUENCY(IF(A2:A10<>"",
    MATCH("~"&A2:A10,A2:A10&"",0)),ROW(A2:A10)-ROW(A2)+1)>1,1)),
     {0,1},{"No Dups","Dups Exist"})

tells either No Dups or Dups Exist.

 

[West Man]

Thank you very much Aladin. I never would have obtained a solution on my own.

 

[Aladin Akyurek]

Thank you very much Aladin. I never would have obtained a solution on my own.

You are welcome. Thanks much for the feedback.