Text matching

[Paul Hyett]

Here's the set-up :

I have two columns, say A & B, each containing 1000 (text) entries.

I'd like to set up a formula in column C (for each row) to alert me of
any entries in column B that are not in column A.

Can you help me with the syntax for the formula (Excel 2003)?

Hope I've explained it well enough...

TIA.

 

[Pete_UK]

You could put this in C1:

=IF(ISNUMBER(MATCH(B1,A:A,0)),"matched","not present")

then copy down as far as needed.

Hope this helps.

Pete

 

[Paul Hyett]

You could put this in C1:

=IF(ISNUMBER(MATCH(B1,A:A,0)),"matched","not present")

then copy down as far as needed.

Hope this helps.

Thank you - that did the trick.

 

[Michael.Tarnowski]

Here's the set-up :

I have two columns, say A & B, each containing 1000 (text) entries.

I'd like to set up a formula in column C (for each row) to alert me of
any entries in column B that are not in column A.

Can you help me with the syntax for the formula (Excel 2003)?

Hope I've explained it well enough...

TIA.

Hi Paul,

there is a very interesting article at Chamdoo.org,
http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/

you may look at.
HTH, cheers, have a nice day
Michael