Getting together

H

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
 
R

robert111

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

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

harvindersingh1

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

In other words, does it read blank,b,c,d,blank OR b,c,d?
Click to expand...

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

Bryan Hessey

Robert111,

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

---

harvindersingh1 - I do not know you and, as such, would not answe
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 answere
queries believed that you bothered to return and read their replies.
A quick check on posts originated by you shows only one response, tha
being the clarification shown below.

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

If you mean a literal "A, etc then what is the match to be made on, Ro
number?
If it is 5 elements, and you want to match elements B C and D then yo
may need to split column A into two parts, using B C D for a looku
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 entrie
in column A of this sheet to be universal set entries.Similarly I hav
data in Column A of sheet2, treat these entries to be subset entries o
the sheet1 entries. Now, I want the missing entries(complementar
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 n
blanks only the subset entries are there in sheet 2 column A and i wan
rest of the entries in column B..
Click to expand...

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