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!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Norie

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

Watch MrExcel Video

Forum statistics

Threads
1,118,781
Messages
5,574,218
Members
412,578
Latest member
jamiedaka
Top