Repeat Formula Question

excel_training_wheels

Board Regular
Joined
Aug 25, 2005
Messages
193
Any suggestions for a formula which can identify when a word repeats?

ColumnA ColumnB
dog
dog
cat
bird
snake
snake
snake

I would like the formula in column b to flag the second *dog* and the second and third *snake*. I have 9,000 words in my list, and am trying to get a distinct list (and ignore the repeats).

THX for help!
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,365
Office Version
365
Platform
Windows
If you want a distinct list why not use Data>Advanced Filter...?
 

Forum statistics

Threads
1,082,641
Messages
5,366,717
Members
400,915
Latest member
NFlem

Some videos you may like

This Week's Hot Topics

Top