Here is an example. Say your codes are in column A from A1 thru A20. Say
the NY codes are in column B from B1 thru B100. In C1 enter:

=COUNTIF($A$1:$A$20,B1)

and copy down to match all the B's. A zero in C means its not in your list.
A one in C means its in your list. Just sort B&C by C. All the zeros will
be at the top.
--
Gary''s Student - gsnu200753


"Johnny" wrote:

I have a list of NY State zip codes I provide service in. I combined that
with a list of all zip codes in NY State. I need to show just the zips I
don't provide service in.
How do I do that quickly.