自动过滤多个不相等的值 [英] Autofilter for multiple not equal values

问题描述

我正在为excel表添加自动过滤器，如下所示.

I am adding autofilter for excel table as follows.

With Sheets("Sheet1")
With .ListObjects("Summary").Range
    .AutoFilter Field:=1, Criteria1:=">400000", Operator:=xlOr, Criteria2:=Array("<>440400", "<>440600", "<>440300")
    .AutoFilter Field:=5, Criteria1:=">110", Operator:=xlAnd, Criteria1:="<105"
    .SpecialCells(xlCellTypeVisible).Copy
End With
End With

结果我的geeting值大于400000.但是我也得到了440400,440600和440300的值.如何添加两个过滤器?

n the result I am geeting value greater than 400000 . But I am getting 440400,440600 and 440300 values also in the result. How Can I add both filters?

推荐答案

到目前为止，据我所知，这是无法完成的.

So far, as I know, it cannot be done.

我的解决方法:

1)高亮显示符合条件的记录，一一循环

1) Highlight records that meet criteria, loop one by one

2)然后通过Higlight过滤

2) Then Filter by Higlight

希望这项帮助！

这篇关于自动过滤多个不相等的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！