Finding duplicates within a column
 

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

Finding duplicates within a column
 

see reply to your earlier posting

--
Regards

Roger Govier


"Cynthia Amrit" <Cynthia wrote in
message ...
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

Finding duplicates within a column
 

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.



--
SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA


"Cynthia Amrit" wrote:

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