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


--
Tess

In C1, add

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

and copy down

--

HTH

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


"Tess" wrote in message
...
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


--
Tess