Text matching

  • Thread starter Thread starter Paul Hyett
  • Start date Start date
P

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.
 
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
 
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.
Click to expand...

Thank you - that did the trick. :)
 
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.
Click to expand...

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
 
Back
Top