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
|