how can I match numbers from two columns?

[Lea]

I have two large columns with numbers. I need to check what numbers from
column 2 are already in column 1.
Example:

25 55
20 25 Already in column A
19 42
31 20 Already in column A

That's all I need. A formula in column C that tell me what numbers from
column B are already in column A.
Anny suggestions? Thanks!


Thanks a lot

[kk]

Hi Lea,

Try =If(Countif($A$1:$A$100,B1)>0,"Duplicate","")


"Lea" <Lea@discussions.microsoft.com> wrote in message
news:5CCDAE5E-4A77-448D-8ADD-91CBCC32416F@microsoft.com...
I have two large columns with numbers. I need to check what numbers from
column 2 are already in column 1.
Example:

25 55
20 25 Already in column A
19 42
31 20 Already in column A

That's all I need. A formula in column C that tell me what numbers from
column B are already in column A.
Anny suggestions? Thanks!


Thanks a lot