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:
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?

On Tue, 23 Oct 2012 04:04:42 +0000, Gryf wrote:


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?

Select the region to be formatted (e.g. A1:F8), then use this:

=COUNTIF($A1:$F1,A1)1