How to compare two columns of info

[dmb41]

I have a list of several items and need to see which item is in both rows:

e.g.

Column A Column B
X4567 X4578
X4578 X1125
X8777 X4567
.
.
.
etc

(The list is much longer)

Would the Match function work?

 

[bryonwoods30]

in c1 you could use
=COUNTIF(A:A,B1)
then you can filter by column c and choose just the 1's and those values are in both columns.

 

[dmb41]

Thanks that's exactly what I needed!