Advanced Filter does not work in this one
 

My Criteria is the following

Ticker Move
FCX =10%
ACF


When I run this against my database, it does not filter given the rule.
I read the above rule as Ticker is FCX OR ACF and Move is =10%.

any help appreciated.

thanks

Advanced Filter does not work in this one
 

This is interpreted as: FCX AND =10%
OR ACF

Add the =10% on both lines.

Ticker Move
FCX =10%
ACF =10%

Krish wrote:
My Criteria is the following

Ticker Move
FCX =10%
ACF


When I run this against my database, it does not filter given the rule.
I read the above rule as Ticker is FCX OR ACF and Move is =10%.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html