compare 2 col with results

[Joanne]

i have 2 columns of numbers. I want to find out if a number in col 1 is in
col 2. If it's not, I want it flagged some how or a new col created showing
what is not in col 2. Can you help? thanks, Joanne

 

[Fred Smith]

Use Countif, as in:
=countif(a:a,b1)
and copy down.

A result of zero means it's not in column A.

Regards,
Fred

 

[helene and gabor]

Hello Joanne,

Fred's advice is simple and doable.
Two comments:

1. You have a set of numbers in column A and in column B.
You could copy column A into a blank section of your worksheet and Colum B
numbers under the column A numbers,leaving one free line in between..
With Excel 2007 you could click on Data, Remove Duplicates. This leaves
column B unique numbers only. (the reverse order for unique column A
numbers)

2. If you want to be more verbose,in column D you could enter: A1&" in B ?"
A2 &" in B? "

and the answers in column E:
if(countif($B$1:$B$7,A1)=1,"yes","no")

Regards,

Gabor Sebo

i have 2 columns of numbers. I want to find out if a number in col 1 is in
col 2. If it's not, I want it flagged some how or a new col created
showing
what is not in col 2. Can you help? thanks, Joanne