how to find duplicates strings based on specific condition

[amir988]

i have string data in excel more then 20k cells. in b1 i want to get the message if the all strings of a single cell are matched with any other cell in whole 20k like below. How can i do this...

above you can see i have data in A and in B i need details like above.

note: (there is no duplicates in general in A)

How can i do this.... thank,s,,,

 

[ExceLoki]

try this

=IF(COUNTIF($A$2:$A$20000,"="&A2)>1,"match","unique")

 

[amir988]

try this

=IF(COUNTIF($A$2:$A$20000,"="&A2)>1,"match","unique")

It does not tell where the match found..... and its not working.... it says "unique" every time

 

[amir988]

update: cells contain more strings then then the one whom it matched. for example,

a1 contains 22 strings
a2 contains a1 strings + 13 more strings....
a3 contains only 20 strings of a1 and 10 more.
in b1... it display the message "contain all string in a2"
in b2 it dispplay "unique"
in b3 it also display "unique" (because it does not contain all strings in any cell)

 

[ExceLoki]

ahh ok. misunderstood initial request

 

[amir988]

ahh ok. misunderstood initial request

Whats the way now