从多维数组中的TODAY()获取标头行值 [英] Get header row value from TODAY() found in multi-D array

问题描述

我有一个多日期数组(例如"F3:AO21")，并且想使用TODAY()查找该数组中哪列与TODAY()相匹配.找到后，返回匹配列的值，但始终返回第2行.

I have a Multi-D array of dates (say "F3:AO21"), and want to use TODAY() to find which column in that array matches TODAY(). Once found, to return the value of the matching column, but always row 2.

无论找到了什么TODAY()列，返回的值都应该始终是:Column =找到的TODAY()列；行=第2行.

No matter what column TODAY() is found, the value returned should always be: Column = column of TODAY() found; Row = row 2.

谢谢，杰森.

推荐答案

在索引中使用AGGREGATE:

Use AGGREGATE inside an INDEX:

=INDEX(2:2,AGGREGATE(15,7,COLUMN(F3:AO21)/(F3:AO21=TODAY()),1))

这篇关于从多维数组中的TODAY()获取标头行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！