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.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

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

On Jun 11, 10:56*am, Paul Hyett <vidcap...@invalid83261.co.uk> wrote:
> 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.
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Fri, 11 Jun 2010 at 05:29:38, Pete_UK <(E-Mail Removed)> wrote in
microsoft.public.excel :

>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.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Jun 11, 11:56*am, Paul Hyett <vidcap...@invalid83261.co.uk> wrote:
> 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.
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Hi Paul,

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

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