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?
|