Advanced Filter Question

[carl]

I am trying to use the advanced filter to show me
the firms that average more than 100 but have a change
greater than -.50. The change is a calculation. I cant
seem to get the advanced filter to work.

Average % Change

100

<-.50
Firm ID Average % Change
BOX005 520 0.98
BOX017 74856 -0.80
BOX019 0
BOX030 0

TRying to create a table like so...

Firm ID Average % Change
BOX017 74856 -0.80


Thank you in advance

 

[Debra Dalgleish]

Put both criteria on the same row:

Average % Change

100 <-.50

If you have them on different rows, the filter uses an OR operator, e.g.
Average >100 OR %Change <-.5