Ive got two columns filled with email addresses. I want to take out from column A any email addresses that are in column B - how do I do that?

if statement, not enough time to write it out now but it should give you a chance if you shove if into an excel cell.

http://support.microsoft.com/kb/213367

Cheers mate did the trick.