1. ## Advanced filter criteria (Excel 2000)

I dont' do this that often and Excel's help doesn't show this well: In the Advanced Filter criteria line, I want to filter on a field x for a number greater than or equal to 5400 and less than or equal to 6900. I am never sure whether the = goes first or last vs the >. Plus, would those be on two separate lines or in one cell below the field x in the criteria range? Thanks.

2. ## Re: Advanced filter criteria (Excel 2000)

1. As in the way you say and write it, the "greater than" or "less than" sign comes before the "equal" sign.
2. You must use two columns for the field x in the criteria range, put the "greater than or equal" condition under one, and the "less than or equal" condition under the other.

<table border=1><td>x</td><td>x</td><td>>=5400</td><td><=6900</td></table>
Conditions in the same row, next to each other, are "AND" conditions: both must be satisfied. Conditions in the same column, one below the other, are "OR" conditions: at least one must be satisfied.

3. ## Re: Advanced filter criteria (Excel 2000)

You can do it with 1 column if you use a formula.
Leave the first row of the criteria blank and put in a formula like below (change A2 to the first cell of the row you want to compare:

<blank>
=AND(A2>=5400,A2<=6900)

Steve

4. ## Re: Advanced filter criteria (Excel 2000)

Not sure about the "row I want to compare" in the array column F has the set of numbers. That would make it =ANd(f2>=5400,<=6900), correct?

5. ## Re: Advanced filter criteria (Excel 2000)

If row1 has the headder so row 2 is the first row of data, yes row2 is what I was refering to: The equation needs both F2 references:
=AND(F2>=5400,F2<=6900)

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•