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?