Advanced Filter: No Filter

  • Thread starter Evan Weiner - Richalnd WA
  • Start date
E

Evan Weiner - Richalnd WA

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

Peo Sjoblom

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
 
Top