I have a dataset that includes a coulmn of product codes-aprox 10'000
entires e.g

Prod Code Value
01023456 12
01204895 19
02857867 34
05292453 24
90235905 65

There is other data in differnet columns, with entries relavent to the
product codes. As you can see in my example with the value.

I have anothe list of codes - aprox 250 (that i call exceptions) that
are included in the above table that i want eliminate. Is there a
formula to do this

e.g

Exceptions
01023456
05292453

Thankyou for your help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=505319