答案1
这将返回K, P
& 1, 7
。
=INDEX(FILTER($A$1:$B$9,$B$1:$B$9<>""),SORT(SEQUENCE(2,1,SUM(--($B$1:$B$9<>"")),-1)),{1,2})
这将返回K, P
:
=INDEX(FILTER($A$1:$B$9,$B$1:$B$9<>""),SORT(SEQUENCE(2,1,SUM(--($B$1:$B$9<>"")),-1)))
这将返回数字的总和(8
):
=SUM(INDEX(FILTER($A$1:$B$9,$B$1:$B$9<>""),SORT(SEQUENCE(2,1,SUM(--($B$1:$B$9<>"")),-1)),2))
进一步阅读: https://exceljet.net/formula/filter-on-first-or-last-n-values