compare 2 col with results

  • Thread starter Thread starter Joanne
  • Start date Start date
J

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
 
Use Countif, as in:
=countif(a:a,b1)
and copy down.

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

Regards,
Fred
 
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


Joanne said:
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
Click to expand...
 
Back
Top