Excel-高级筛选器:筛选值大于今天 [英] Excel - Advanced Filter: Filter values greater than today

问题描述

我正在尝试使用Advanced Filter而不是AutoFilter，因为我被告知它在VBA中的性能要好得多.但是，我似乎无法找到一种方法来过滤数据以仅显示比今天大的日期，因为该方法是动态的并且依赖于公式.

I'm trying to make use of Advanced Filter instead of AutoFilter as I'm told it performs much better in VBA. However, I can't seem to figure out a way to filter data to only show dates greater than today since that is dynamic and relies on a formula.

我尝试将我的条件范围设置为> today()和>"& B2 ，其中 B2 是 today()

I've tried making my criteria range >today() and ">"&B2 where B2 is today()

知道我缺少什么吗?

高级过滤器:

之前的数据:

所需结果:

推荐答案

在高级"过滤器中使用公式时，公式本身就是过滤器.从条件中删除标题，然后将公式指向要过滤的列数据中的第一个单元格.在这种情况下:

When using a formula in Advanced filter the formula itself is the filter. Remove the title from the criteria and point the formula at the first cell in the column data to be filtered. In this case:

=A2>TODAY()

所以:

条件必须在上面包含空白单元格:

The Criteria must include the blank cell above:

然后我们得到:

这篇关于Excel-高级筛选器:筛选值大于今天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！