I have two sheets, the sheet1 contains data in column A, treat entries in column A of this sheet to be universal set entries.Similarly I have data in Column A of sheet2, treat these entries to be subset entries of the sheet1 entries. Now, I want the missing entries(complementary entries) in column B of sheet 2.

Let me explain with the help of example:
Sheet1, column A contains entries A,B,C,D & E
Sheet2, Column A contains entries B,C,D

Now, I want sheet2 column B should contain entries A,E.

With Regards
Harvinder