Duplicate entries between two columns

M

mazalam

Need some help with an excel formula.

I have column A with 962 entries. I have column B with 898 entries. I
want to find out the matched entries of the two columns in Column C.

Thanks,

Mazhar :rolleyes:
 
D

Dave Peterson

Put this in C1:

=isnumber(match(b1,a:a,0))

and drag down.

True's will mean that B has a match somewhere in column A.
 
B

BenjieLop

mazalam said:
Need some help with an excel formula.

I have column A with 962 entries. I have column B with 898 entries.
want to find out the matched entries of the two columns in Column C.

Thanks,

Mazhar :rolleyes:
Click to expand...


Try this in Column C (starting in Cell C1 and copy all the way dow
until your requirements are met)

=IF(COUNTIF($A$1:$A$962,B1)>0,\"DUPLICATE\",\"\"

This formula will indicate what entries in Column B are also in Colum
A. I hope I understood your post correctly.

Regards
 
Top