Intersection

[Guest]

I have 2 columns of alphanumeric characters, some of which are common to both columns and some of which are unique to either column. I'd like to see which are common to both. Is there a way to figure this out using Excel?

 

[Guest]

Hi

I would use a countif formula.

Eg. =countif($A$1:$A$1000,B1)

This formula would look at the value in cell B1 and tell
you how many times it occurs in the column A1:A1000.

You could do the reverse to find out the duplications in
column B.

All results greater than 2 would equal a duplication, 1
would be unique.

Hope this helps

Cheers
Patrick

-----Original Message-----
I have 2 columns of alphanumeric characters, some of

which are common to both columns and some of which are
unique to either column. I'd like to see which are common
to both. Is there a way to figure this out using Excel?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon