Let's see if I can be more helpfull this time:

The cells that contain the criteria (ZipMatch and the formula) should be on
the same sheet as the sales data list. The list of 20 zipcodes that you are
interested in matching should be on another sheet.

So, if your 3000 rows of sales information are on Sheet1, the list of 20
zipcodes will be on Sheet 2.

Adjust the references to suit your situation. Post back with any other
questions.

Regards,
Ron

XL2002, WinXP-Pro

------------------------------
"dbusser" wrote:


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