E2=SUMPRODUCT((B$2:B$16-LEFT(D2,FIND("-",D2)-1)>=0)*(B$2:B$16-MID(D2,FIND("-",D2)+1,9)<=0))
E2適用整數=SUMPRODUCT(COUNTIF(B:B,ROW(INDIRECT(SUBSTITUTE(D2,"-",":")))))
E2另解=INDEX(FREQUENCY(B:B,MID(D$2:D$4,FIND("-",D$2:D$4)+1,9)*1),ROW(A1))
G2=MID(D2,FIND("-",D2)+1,9)*1
H2=INDEX(FREQUENCY(B:B,G$2:G$4),ROW(A1))
留言
張貼留言