View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

It works fine for me when I change the criteria range to A1:C2, as expected I
get

Joe Moe Hoe
1 abc 21

when I filter in place, I don't know why you are using A1:C4 as criteria
range,
maybe a simple typo?

Regards,

Peo Sjoblom

"Evan Weiner - Richalnd WA" wrote:

I can't get any advanced filter to work. For example, starting at A1 I have:

Joe Moe Hoe
abc


Joe Moe Hoe
1 abc 21
2 12 22

Absolutely nothing happens with
Data Filter
Data range = a4:c6
Criteria range = a1:c4
OK

Any ideas?