引用问题，望大师帮助解决。

84474376

两个日期的引用问题，希望得到帮助解决。

wdy895

E2单元格

1. =LARGE(FILTER($B$2:$B$18,$A$2:$A$18=$D2),2)

复制代码

F2单元格

1. =LARGE(FILTER($B$2:$B$18,$A$2:$A$18=$D2),1)

复制代码

冬不暖

1. =LARGE(IF($A:$A=$D2,$B:$B),3-COLUMN(A1))

复制代码

数组三键，右拉下拉

huaichuan1

E2=LARGE(UNIQUE(IF($D2=$A$2:$A$17,$B$2:$B$17,"A")),2)
F2=LARGE(UNIQUE(IF($D2=$A$2:$A$17,$B$2:$B$17,"A")),1)

84474376

冬不暖 发表于 2024-9-12 15:07
数组三键，右拉下拉

真是高手，厉害，非常感谢！

秃头发师

E2:=MAXIFS(B:B,A:A,D2,B:B,"<>"&F2)
F2:=MAXIFS(B:B,A:A,D2)

wlc5201130

=TEXT(INDEX($B:$B,LARGE(($A$2:$A$18=$D2)*($B$2:$B$18<>"")*ROW($2:$18),3-COLUMN(A1))),"e/m/d")  下拉右拉

00JTR00

1. =SUMPRODUCT(LARGE(IF($A:$A=$D2,$B:$B),{1,2})*{1,-1})

复制代码

84474376

huaichuan1 发表于 2024-9-12 15:10
E2=LARGE(UNIQUE(IF($D2=$A$2:$A$17,$B$2:$B$17,"A")),2)
F2=LARGE(UNIQUE(IF($D2=$A$2:$A$17,$B$2:$B$17, ...

感谢

84474376

wlc5201130 发表于 2024-9-12 15:21
=TEXT(INDEX($B:$B,LARGE(($A$2:$A$18=$D2)*($B$2:$B$18"")*ROW($2:$18),3-COLUMN(A1))),"e/m/d")  下拉右 ...

谢谢！