如何在Excel中过滤多个条件？ [英] How to filter for multiple criteria in Excel?
问题描述
我试图过滤多个条件，但是我看到筛选选项只有AND / OR选项的2个字段。我有一列充满链接。我想提取包含这些内容的所有行：
I am trying to filter for multiple criteria, but I see that the "Filter" option only has 2 fields for "AND/OR" options. I have a column full of links. I want to extract all rows that contain these in it:
.pdf
.doc
.docx
.xls
.xlsx
.rtf
.txt
.csv
.pps
.pdf .doc .docx .xls .xlsx .rtf .txt .csv .pps
有没有办法？
推荐答案
Excel中的常规过滤器选项不允许超过2个条件设置。要执行2+条件设置，您需要使用高级过滤器选项。以下是我尝试过的步骤。
The regular filter options in Excel don't allow for more than 2 criteria settings. To do 2+ criteria settings, you need to use the Advanced Filter option. Below are the steps I did to try this out.
http://www.bettersolutions.com/excel/EDZ483/QT419412321.htm
设置条件。我把这个上面我想要过滤的值。你可以这样做或放在不同的工作表上。请注意，将条件置于行中将使其成为或过滤器，并将其放入列将使其成为AND过滤器。
Set up the criteria. I put this above the values I want to filter. You could do that or put on a different worksheet. Note that putting the criteria in rows will make it an 'OR' filter and putting them in columns will make it an 'AND' filter.
- E1：字母
- E2：= m
- E3：= h
- E4：= j
- E1 : Letters
- E2 : =m
- E3 : =h
- E4 : =j
我把数据从第5行开始：
I put the data starting on row 5:
- A6：
- A7：
- ...
A：
- A5 : Letters
- A6 :
- A7 :
- ...
选择第一个数据行（A6），然后单击高级过滤器选项。列表范围应该预先填充。选择标准范围为E1：E4，然后单击确定。
Select the first data row (A6) and click the Advanced Filter option. The List Range should be pre-populated. Select the Criteria range as E1:E4 and click OK.
应该是这样。请注意，我使用'='运算符。您将需要使用不同的东西来测试文件扩展名。
That should be it. Note that I use the '=' operator. You will want to use something a bit different to test for file extensions.
这篇关于如何在Excel中过滤多个条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
