:) Ron Coderre Wrote:
Try something like this:

Assuming your data is in cells A1:Z3000, with Col_G containing the
ZipCode:

Of to the side of your data (or on another sheet), enter the list of
zipcodes you want to find. I'll put my list on Sheet2, cells A1:A20.

On Sheet 1:
AB1: ZipMatch
AB2: =ISNUMBER(MATCH(G2,Sheet2!$A$1:$A$20,0))

Select your data list
DataFilterAdvanced Filter
List Range: (your already selected data list)
Criteria Range: $AB$1:$AB$2
Click the [OK] button to only display records with addresses in your
zipcode
list.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dbusser" wrote:


Hello Everyone

I have an Excel spreadsheet with abut 3,000 lines of sales
information
exported from a large sales/contact program called Avenue.

This Excel file includes dropship information to several customers
in
California. I would like to be able to sort through this file using
a
multiple ( 20) zip codes filter and pull out information on sales to
specific zip codes. As I have found the custom filter only allows me
to
use 2 zip codes at a time.

Any help would be greatly appreciated.

Dale


--
dbusser

------------------------------------------------------------------------
dbusser's Profile:
http://www.excelforum.com/member.php...o&userid=30924
View this thread:
http://www.excelforum.com/showthread...hreadid=505999



Thank You

You are correct, one column is only zip codes. Where do I enter this
formula?
I understand the filter will be created on sheet 2, and I know where
the advacned filter is found. Do I put this formula in a cell or at the
top?
I see these formulas all over the forum but have no experiece using
them.

Thank You for all your help

Dale


--
dbusser
------------------------------------------------------------------------
dbusser's Profile: http://www.excelforum.com/member.php...o&userid=30924
View this thread: http://www.excelforum.com/showthread...hreadid=505999