"aubudgo" wrote:
I have two columns of numbers. One is a large list with say 3,000
random serial numbers. The other is a smaller list of 800 serial numbers.
I want to find if any serial numbers are listed in both of the columns. I want to
identify which number appear in both columns and move them to another
column, or at least highlight them ..

Try one way via non-array formulas, re this recent post:
http://tinyurl.com/rdhdf

Note that the formula in D2 is just a sweet copy across of the one placed in
C2. To compare it the other way around (compare col B against col A, and
slice the matched and unmatched items into cols C and D), just make a copy of
the original sheet (where col A is compared against col B), then swap the 2
source lists in cols A and B around.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---