displaying data that does not meet criteria

[jerrystan]

Is there a way (in VBA) to display/filter data that does NOT meet a list of criteria. Autofilter only lets me do 2 conditions, I have about 30. Bottom line is I want to delete all rows that don't belong. I know what should belong but don't have a list of what doesn't. Thanks.

[Bob Phillips]

What you could do is to create a list of all valid criteria, and then add a
formula to check if an item is in that list. For instance, the list is in
column A, valid criteria in column J, so in B2 add a formula of

=MATCH(A2,J:J,0)

Then AUtofilter column B, and filter on the #N/A values, and delete the
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jerrystan" <[email protected]> wrote
in message news:[email protected]...
>
> Is there a way (in VBA) to display/filter data that does NOT meet a list
> of criteria. Autofilter only lets me do 2 conditions, I have about 30.
> Bottom line is I want to delete all rows that don't belong. I know what
> should belong but don't have a list of what doesn't. Thanks.
>
>
> --
> jerrystan
> ------------------------------------------------------------------------
> jerrystan's Profile:
http://www.excelforum.com/member.php...o&userid=28573
> View this thread: http://www.excelforum.com/showthread...hreadid=497694
>