Quote:
Originally Posted by DRKENNE
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,"")