Highlight (any) first text word that is a duplicate

[jlr123]

I want to highlight all duplicates based on the first text of each cell in a column. There are many but this based on any duplicate first text word in the column not just a specific text.
E$5:E$132

 

[Andrzejek]

Please provide this information:

1. This is what I have - example of your data.
2. This is what I want - how your data should be [highlight #FCE94F]highlighted[/highlight].

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[SkipVought]

Hi,

I had to add a helper column in column F

[pre]
E F
Mary 3
Skip 2
Mary 2
Skip 1
Mary 1
...
[/pre]
Column F has this formula...
[tt]
F5: =SUMPRODUCT(--(E5:E$9999=E5))
[/tt]
Using Conditional Formatting...
1. SELECT Column E
2. Open the CF Editor
3. Add a new rule using a formula to determine which cells to format
4. Use this formula...
=AND(SUMPRODUCT(--($E:$E=E1))=F1,F1>1)
5. Select your Format
6. Apply the Conditional Formatting rule

The reason I used e5:E$9999=E5 and $E:$E=E1 is in the event that your list of duplicates expands.

[URL unfurl="true"]https://res.cloudinary.com/engineering-com/raw/upload/v1706809896/tips/tt-cf_first_duplicate_t1bg7z.xlsx[/url]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!