高级过滤条件对于多个标准不起作用 [英] Advanced Filter criteria does not work for more than one criterion
问题描述
我试图在Excel(2003)中过滤列。列填充有文件名。我想使用Excel的高级过滤器过滤某些类型的文件。
文件夹列(B)存在于sheet1中,sheet2列B中的过滤器列表。
I am trying to filter a column in Excel (2003). The column is populated with "filenames". I want to filter certain types of files using Excel's "Advanced Filters". The filename column (B) exists in sheet1, and the filter list in sheet2 column B.
sheet1 sheet2
column B column B
1 Heading 1 Heading
2 file.doc 2 <>*.doc
3 file.html 3 <>*.pdf
4 file.pdf 4 <>*.mp3
5 ... 5 ...
This is what I have found after many hours of search on the Internet. The problem is that this works for one entry, but not all. I.e. if I mark the entire column B in sheet1 and use column B1:B2 in sheet2 as the area criteria then Excel filters out all files that end with ".doc". But if I use column B1:B4 in sheet2 then nothing happens.
目前为止我已经尝试过:
What I have tried so far:
- <> *。ext
- =<> *。ext
- OR( .ext, .ext2)
- <>(...)
- ISERROR(SEARCH())
- 和许多更多...
.ext, .ext2)
- "<>*.ext"
- ="<>*.ext"
- OR(.ext,.ext2)
- OR(".ext",".ext2")
- =OR(...)
- <>(...)
- ISERROR(SEARCH())
- and many many more...
我做错了什么?
推荐答案
由于这是一个 OR过滤器,您需要将条件放在同一行中。它应该如下所示:
Since this is an OR filter, you need to put the criteria in the same row. It should look like the following:
Sheet2
Column B Column C
1 Heading Heading
2 <>*.doc <>*.pdf
这是一个很好的帖子高级过滤器: http://searchengineland.com/advanced-filters- excel-amazing-alternative-to-regex-143680 。
Here's an excellent post on advanced filters: http://searchengineland.com/advanced-filters-excels-amazing-alternative-to-regex-143680.
这篇关于高级过滤条件对于多个标准不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!