Maybe you can try something like this:
=IF(COUNTIF($B$1:$B$20,$A$1:$A$20)0,B1,"")

Regards,
Ryan---

--
RyGuy


"Diane" wrote:

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,