輔助E2:E9=MAX(MMULT(COLUMN(A:H)^0,(EOMONTH(DATE(2024,COLUMN(B:Z),),0)>=EOMONTH(N(IF({1},C$2:C$9)),0))*(EOMONTH(DATE(2024,COLUMN(B:Z),),0)<=EOMONTH(N(IF({1},D$2:D$9)),0))*(A$2:A$9=A2)))*(COUNTIF(A$2:A2,A2)=1)+N(E1)
A14:A19=IF(ROW(A1)>MAX(E$2:E$9),"",INDEX(A:A,MATCH(1,FREQUENCY(ROW(A1),$E$2:$E$9),)+1))
B14:J19{=IFERROR(INDEX($B:$B,SMALL(IF(($A$2:$A$9=$A14)*(EOMONTH(B$13,0)>=EOMONTH(N(IF({1},$C$2:$C$9)),0))*(EOMONTH(B$13,0)<=EOMONTH(N(IF({1},$D$2:$D$9)),0)),ROW($2:$9)),COUNTIF($A$14:$A14,$A14))),"")
留言
張貼留言