Data comparison

[Chris Hankin]

Hello,

Could some please help me with the following?

I wish to compare the text in column A of my workbook with the text in
column B to determine all the data in column A which is not contained in
column B.

I have no idea on how to accomplish this task, so any help would be
greatly appreciated.

Thanks,

Chris.

 

[Peter T]

What do you mean by compare? Perhaps a few examples to illustrate.

Regards,
Peter T

 

[Stefi]

If I understood well your question, this formula in C1 (and dragged down as
necessary) returns TRUE if value in column A is found in column B, FALSE
otherwise.

Regards,
Stefi


„Chris Hankin†ezt írta:

 

[Chris]

Thanks Stefi for your reply - however I could not see your formula to
enter in cell C1?

Could you please advise on the formula you mentioned in your reply?

Thanks,

Chris.

 

[Stefi]

Sorry, I forgot to copy it:
=NOT(ISERROR(MATCH(A1,B:B,0)))
Stefi


„Chris†ezt írta:

 

[Chris Hankin]

Thanks Peter for your reply. An example is given below:

Column A: contains the following text data:

Cell A1: 001ABC96-74
Cell A2: RT000-PL/63
Cell A3: M002637-IREWS
Cell A4: 002-PLK

Column B: contains the following text data:

Cell B1: RT000-PL/63
Cell B2: 002-PLK
Cell B3: M002637-IREWS
Cell B4: TR78-LMN-9600

There is a lot more data contained in columns A & B of my workbook, but
this hopefully will give you an idea of what I am trying to do. I need
to compare the two columns such that the following text data is output
to column C:

001ABC96-74
TR78-LMN-9600

There maybe some text data in column A that is not in column B and
conversely, there maybe some text data in column B that is not in column
A.

I hope this helps,

Kind regards,

Chris.

 

[Chris Hankin]

Thanks again Stefi - very much appreciated.

 

[Stefi]

Now it's a bit clearer. Perhaps this formula is closer to your needs:
=IF(ISERROR(MATCH(A1,B:B,0)),A1,"")
Stefi


„Chris Hankin†ezt írta:

 

[Peter T]

Adapting Stefi's formula

C1: =IF(ISERROR(MATCH(A1,B:B,0)),A1,"")
D1: =IF(ISERROR(MATCH(B1,A:A,0)),B1,"")

Copy C11 down

Copy and PasteSpecial Values elsewhere and sort

Regards,
Peter T

 

[Chris Hankin]

Thanks Stefi - I will give your new formula a try - thanks again for all
your excellent help - greatly appreciated.

Cheers,

Chris.

 

[Chris Hankin]

Thanks Peter for all your help - very much appreciated.

Kind regards,

Chris.