Match

T

Tess

I need to match two columns. In this case I would like to find all the
numbers in columns A that also appears in columns B.

For exempel:

A B

1 2
2 3
3 3
4 4
5 7

Rresults:
A B

2 2
3 3
3
4 4
 
B

Bob Phillips

In C1, add

=IF(COUNTIF(B:B,A1)>0,"Match","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top