OK, Think I now understand what you're after

Here's one way:
Assumed your table is in A1 to B5
In C1, enter a heading for your check
In C2 enter
=--NOT(COUNTIF($A$2:$A$5,B2))
Copy down
Whilst in the table select Data-Filter-Autofilter
In the dropdown box in C1 select 0
This highlights all entries in column B to be deleted
Delete these entries in column 2
Dump the filter and column C.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531738