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,275
If you want a distinct list why not use Data>Advanced Filter...?
 

Forum statistics

Threads
1,078,121
Messages
5,338,343
Members
399,228
Latest member
Bucephalas

Some videos you may like

This Week's Hot Topics

Top