D6:D15=IF(ROW(A1)+RIGHT(B$6,5)-1-RIGHT(LOOKUP("嫻",B$6:B$99),5)>0,"",LEFT(B$6,5)&ROW(A1)+RIGHT(B$6,5)-1)
I6 下拉=IF(ROW(A1)=1,H6,IF(IFERROR(MID(I5,8+(RIGHT(I5,4)*1<0)*4,9)+MID(I5,6,2)*1000,"A")>=MID(LOOKUP("嫻",F$6:F99),8+(RIGHT(LOOKUP("嫻",F$6:F99),4)*1<0)*4,9)+MID(LOOKUP("嫻",F$6:F99),6,2)*1000,"",IFERROR(LOOKUP(1,0/FIND(LEFT(I5,5)&RIGHT(I5,5)+1&"-",F$6:F25),F$6:F25),LEFT(I5,7)&RIGHT(I5,3)+1)))
留言
張貼留言