Match

[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


--
Tess

[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)


"Tess" <[email protected]> wrote in message
news:[email protected]...
> 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