Try it

http://www.j-walk.com/SS/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Diane" escreveu:

Group,
I have duplicate customer numbers in column1, I then filter this column for
unique records and placing in column 3. Column 1 contains 1661 rows, column
3 contains 1492 rows, now I want to create a formula in column 5 that
compares 1 from 2 and lists the missing numbers. I know this is a simple
formula, can someone get me started?
Thanks,