Advanced Filter Question

  • Thread starter Thread starter carl
  • Start date Start date
C

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
Click to expand...
<-.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
 
Put both criteria on the same row:

Average % Change
100 <-.50
Click to expand...

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