View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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