Quote:
Originally Posted by Gryf
I have a huge sheets of text strings that I need to find duplicates when they are in a single row. I *can* have duplicates in the sheet, but cannot have the duplicates reside in a row.
How would I write the formula to identify duplicates in a row?
Example:
Code:
A B C D E F
1 Jane Jim John Link Trey Mike
2 John Jim Link Trey Mike Jane
3 Jim John Trey Mike Link Jane
4 John Jim Mike Link Trey Jane
5 Mike John Trey Jim Jane Link
6 John Jim Mike Trey Link Jane
7 Mike Link John Jim Jim Jim
8 Jane John Mike Link Trey Jim
Row 7 has duplicates (7d, 7e,7f) that should get highlighted but the other columns and rows should be fine (Unless I goofed). How do I do that? |
=COUNTIF(A:A,A1)1
Highlight the rows you have data in, starting at row 1.
Enter the above formula into conditional formatting and select the colour you want the cells highlighted.
Does that work for you?