Thanks that worked


"GoBow777" wrote:


DRKENNE;670879 Wrote:
I have two columns with 1000+ numbers in them. Column 1 is the correct

column. I want to compare columns 1 and 2 and move those in #2 that
don't
match or appear in #1 to a third column. End result should be #' 1 and
2
match and a third column contains #'s that were in #2 but didn't match
#1.
make any sense?

This formula will show the unique numbers in column B that are not
found in column A; paste it in cell C2 and copy down.

=IF(COUNTIF($A:$A,B2)=0,B2,"")




--
GoBow777