D2=LOOKUP(1,0/(B2-LEFT(I$2:I$9,FIND("-",I$2:I$9)-1)>=0)/(H$2:H$9=A2),J$2:J$9)
另解=LOOKUP(1,0/(ISERR(FIND("-",IMSUB(B2&-B2&"i",$I$2:$I$9&"i")))*(A2=$H$2:$H$9)),$J$2:$J$9)
另解=LOOKUP(1,0/(H$2:H$9=A2)/(MMULT(SIGN(B2-MID(I$2:I$9,1+FIND("-",I$2:I$9)*{0,1},FIND("-",I$2:I$9)-{1,-9})),{1;1})=0),J$2:J$9)
留言
張貼留言