View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diane Diane is offline
external usenet poster
 
Posts: 96
Default Compare values of two columns

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,