How do I use advanced filters in excel?
 

I am using an advanced filter to and it is only filtering one part of of
input. How do i get it to filter all of my input?

Products that begin with letter A and units greater than 7,500 or product
equal to Zebram date greather than 12/31/2004, and dollars less than 3,000.
It is filtering the Zebra part not the first part of or statment.

What do i need to do?

How do I use advanced filters in excel?
 

The date criterion may be causing the problem. Try entering the date in
a separate cell, then referring to it in the criteria cell, e.g.:

=""&J1

where J1 contains the date.

Jessica wrote:
I am using an advanced filter to and it is only filtering one part of of
input. How do i get it to filter all of my input?

Products that begin with letter A and units greater than 7,500 or product
equal to Zebram date greather than 12/31/2004, and dollars less than 3,000.
It is filtering the Zebra part not the first part of or statment.

What do i need to do?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html