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
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
CF for A2:F3
=AND(ISTEXT(A2),COUNTIF($A$2:$F$3,A2)>1)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks