One play which drives it out ..
Assume source data in cols A and B, in row 2 down
In C2: =IF(B2="","",IF(ISNUMBER(MATCH(B2,A:A,0)),"",ROW() ))
Leave C1 blank
In D2:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(B:B,SMALL(C:C,R OWS($1:1))))
Select C2:D2, copy down to cover the max expected extent of data in col B,
say down to D5000? Minmize/hide col C. Col D will return what you seek.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DRKENNE" 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?