同编码 日期 取最早最晚 (11190)

二項不重複 E2:F7{=IFERROR(OFFSET(A$1,MATCH(,COUNTIFS($E$1:$E1,$A$2:$A$21,$F$1:$F1,$B$2:$B$21),),),"")

G2:H7{=IF(E2="","",INDEX(PERCENTILE(IF(($A$2:$A$21=$E2)*($B$2:$B$21=$F2),$C$2:$C$21*1),{0,1}),COLUMN(A1)))