"Joshua" wrote:
Will this work for Alphanumeric as well as numeric?

Yes, I think so. Easiest way is to play with
the sample file provided earlier, viz.:

http://www.savefile.com/files/9916738
Compare MultiCol n List Common n Unique Items.xls

In the sheet: Combined, you could quickly test by just changing the entries
within A2:A10 to numbers, alphas or alphanums, then see whether the correct
results are returned in cols M to P
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---