Finding duplicates within a column

[Cynthia Amrit]

I need to find duplicates within a column. I want it to say what is the
duplicate and the non duplicate to blank in column B.


A B
Dog Dog
Fish
Dog
Cat Cat
Rabbit
Cat

 

[Roger Govier]

Hi Cynthia

In B1
=IF(COUNTIF(A:A,A1)>1,A1,"")
copy down column B as far as required.

 

[Matt]

Hi could someone help me with something similar, i have two sets of data and
i need to find duplicates please like the formula below but with a little
extra.

I have 2 different spreadsheets with some of the same account numbers on but
on one spreadsheet next to the account number is a unique id which is what to
stay next to the account number. Next spreadsheet has just account numbers
and i want to see if the account numbers match the account numbers with the ID
From spreadsheet A would be the account numbers and spreadhseet B would be
the account numbers and the correct ID numbers next to it, they cannot be
seperated as they are already in order if that makes sense.

If i use the formula below it correct the ones that match but i have a row c
with the account id's and they need to follow row B which is the correct
account number it is assigned too.

Hope this makes sense?

 

[Madwitch]

Hi

I too need some help on something similar. I have three worksheets on each
of which there is a column with a cost centre code (up to 10 codes used) and
a column with a unique ID number. I need to find duplicates of the unique ID
number across the three worksheets. Eg if A1234 56789 appears on worksheet A
and also appears on either B or C or both.

Thanks in advance