software

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.:

=quot;gt;quot;amp;J1

where J1 contains the date.

Jessica wrote:
gt; I am using an advanced filter to and it is only filtering one part of of
gt; input. How do i get it to filter all of my input?
gt;
gt; Products that begin with letter A and units greater than 7,500 or product
gt; equal to Zebram date greather than 12/31/2004, and dollars less than 3,000.
gt; It is filtering the Zebra part not the first part of or statment.
gt;
gt; What do i need to do?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html