Excel - 带通配符的高级过滤器 [英] Excel - Advanced filter with wildcards

问题描述

我正在尝试根据我在此处找到的信息过滤(数据 >排序和过滤器"下的高级")一系列基于通配符+文本的字段:

我不希望以红色突出显示的输出包含在过滤结果中.剩下的3个项目.

解决方案

请尝试以下标准:

="=*-1"

这是可行的，因为我们可以将通配符与这些逻辑运算符混合使用，如下所述以检查完全匹配:

I am trying to filter (DATA > Advanced under "Sort & Filter) a range of fields based on a wildcard + text based on the info I'm finding here: https://www.contextures.com/xladvfilter01.html

But when I use the * wildcard, it is returning filtered results such as *string*, instead of *string. For instance, I am using *-1 to try and get any field in this column ending in "-1", but I am receiving results such as 15-110 (with -1 in the middle).

Sample:

I don't want the output highlighted in red to be included in the filtered results. Just the remaining 3 items.

解决方案

Try the following as your criteria:

="=*-1"

This would work because we can mix up a wildcard with these logical operators as described as below to check for an exact match:

这篇关于Excel - 带通配符的高级过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！