我试图在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 ...这是我在许多之后发现的内容在互联网上搜索的时间。问题是这适用于一个条目,但不是全部。即如果我在sheet1中标记整个列B,并使用sheet2中的列B1:B2作为区域标准,则Excel过滤掉以.doc结尾的所有文件。但是如果我在sheet2中使用列B1:B4,那么没有任何反应。
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 .ext, .ext2)
- OR( .ext, .ext2)
- <>(...)
- ISERROR(SEARCH())
- 和许多更多...
- "<>*.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这是一个很好的帖子高级过滤器: searchengineland/advanced-filters- excel-amazing-alternative-to-regex-143680 。
Here's an excellent post on advanced filters: searchengineland/advanced-filters-excels-amazing-alternative-to-regex-143680.
更多推荐
高级过滤条件对于多个标准不起作用
发布评论