Finding duplicates within a column

[Cynthia Amrit]

I am looking for duplicates within column A and in column B I want it to say
the duplicates and then the non-duplicates I want to be blank.

Column A Column B
Fish Fish
Dog
Rabbit Rabbit
Fish
Rabbit

 

[Roger Govier]

see reply to your earlier posting

 

[SAWTHEYA SAWTHEYA SAWTHEYA]

Hi Cynthia,

There is option.
Go to Column C and type
=EXACT(A1:A5,B1:B5)

It will return the following results.
A B C
1 Fish Fish True
2 Dog
3 Rabbit Rabbit
4 Fish
5 Rabbit


Copy the content in C1 and paste it in the rest of the cells (C2 to C5)

The result will be shown as follows in Column C

C
1. True
2. False
3. True
4. False
5. False

All the results that are "True" are Duplicates.