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?

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