display data in Excel columns.

Hi,
I have some data in an Excel spreadsheet.
For Eg :
Col A : 1,2,3,4,5,6,7,8,9
Col B : 2,4,7

I want Col C = A intersection B

i.e. Col C = 1,3,5,6,8,9
All the values in Col A which are not in Col B.

thanks a lot