Getting together

[harvindersingh1]

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

[robert111]

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?

[harvindersingh1]

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.

[Bryan Hessey]

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

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
=========

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.