you have excel 2007 select both columns and use remove duplicates from the data tab