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


--
harvindersingh1
------------------------------------------------------------------------
harvindersingh1's Profile: http://www.excelforum.com/member.php...o&userid=31725
View this thread: http://www.excelforum.com/showthread...hreadid=533646