Excel comparison

Hi all

Is there a way to compare 2 excel spreadsheets. I have 2 spreadsheets that are mailing lists that i need to compare a column in each, remove duplicate entries and then create a third sheet with the comparison. Is this possible

Thanks