F2:F17{=OFFSET($A$1,SMALL(IF(MONTH(C$2:C$6)-MONTH(B$2:B$6)+(YEAR(C$2:C$6)-YEAR(B$2:B$6))*12+1>=COLUMN(A:Z),ROW($1:$5),99),ROW(A1)),)&""
G2:G17=IF(F2="","",EOMONTH(VLOOKUP(F2,A:B,2,),COUNTIF(F$2:F2,F2)-1))
H2:H17{=IF(F2="","",VLOOKUP(F2,A:D,4,)/(SUM(VLOOKUP(F2,A:D,{2,3},)*{-1,1})+1)*(INDEX(FREQUENCY(ROW(INDIRECT(EOMONTH(G2,-1)+1&":"&EOMONTH(G2,0))),VLOOKUP(F2,A:D,{2,3},)-{1,0}),2)))
留言
張貼留言