AD2:AF2=TEXT(LEFTB($A1,2)&-COLUMN(AC1),"D;;;")
B3:AF3=IF(((LEFTB($A1,2)*1&-(0&B2))-$A6>0)+(B2=""),"",SUMPRODUCT((TEXT(LEFTB($A1,2)&-1,"EMMDD")-TEXT($AJ2:$AJ99,"EMMDD")<=0)*(TEXT(LEFTB($A1,2)&-B2,"EMMDD")-TEXT($AJ2:$AJ99,"EMMDD")>=0)*($AL2:$AL99="改善")))
留言
張貼留言