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

if cell A2 on first sheet contains "b", does cell A2 on second sheet
contain "b"?

In other words, does it read blank,b,c,d,blank OR b,c,d?


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

robert111 Wrote:
if cell A2 on first sheet contains "b", does cell A2 on second sheet
contain "b"?

In other words, does it read blank,b,c,d,blank OR b,c,d?

The second sheet data is also placed randomly. I mean there are no
blanks only the subset entries are there in sheet 2 column A and i want
rest of the entries in column B.


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

Robert111,

perhaps this is better explained in the private email left for me by
harvindersingh1.

---

harvindersingh1 - I do not know you and, as such, would not answer
private queries, you will get much better response from the Forum,
thats why its here.

Your queries would also be answered more quickly if those who answered
queries believed that you bothered to return and read their replies.
A quick check on posts originated by you shows only one response, that
being the clarification shown below.

Your question, on reading, is not clear. does the A,B,C,D,E in column A
of sheet 1 mean a literal "A,B,C,D,E" or that it contains up to 5
elements labelled A B C D & E ?

If you mean a literal "A, etc then what is the match to be made on, Row
number?
If it is 5 elements, and you want to match elements B C and D then you
may need to split column A into two parts, using B C D for a lookup
table, and A,E for the extra to be added.

Please keep all communication within the Forum


harvindersingh1 Wrote:

can you solve this problem for me

--------------------------------------------------------------------------------

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.

The second sheet data is also placed randomly. I mean there are no
blanks only the subset entries are there in sheet 2 column A and i want
rest of the entries in column B..

=========
End of email
=========

harvindersingh1 Wrote:
The second sheet data is also placed randomly. I mean there are no
blanks only the subset entries are there in sheet 2 column A and i want
rest of the entries in column B.


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