TRUE/FALSE if Duplicate texts are present in a string

[Dr. Shivaji Saha]

Hi,

I have a data array mixed with number and text. I want know if duplicate texts are present in that array. And also, I would like to highlight the cells containing duplicate texts.

Thanks

[JohnTopley]

CF for A2:F3

=AND(ISTEXT(A2),COUNTIF($A$2:$F$3,A2)>1)

[Dr. Shivaji Saha]

Thanks! I appreciate your help.

So, I have to write the formula 50 times if I have a sheet with 100 rows. How can I get the result as TRUE/FALSE instead of highlighting the cells?

[JohnTopley]

Your sample file almost certainly over simplifies the problem: what is the result is there is duplication in only one row of a pair of rows?

[JohnTopley]

A row by row formula

in H2

=IF(OR(COUNTIF($A2:$F2,$A2)=2,COUNTIF($A2:$F2,$C2)=2,COUNTIF($A2:$F2,$E2)=2),"True","")

copy down