L2:M11{=TEXT(RIGHT(SMALL(IF({1,0},MMULT(ISERR(FIND(MID($H$2:$H$11,{1,2,3,4},1),$G$2:$G$11))*MID($H$2:$H$11,{1,2,3,4},1),{1;1;1;1})/1%%+$H$2:$H$11,MMULT(ISERR(FIND(MID($I$2:$I$11,{1,2,3,4},1),$J$2:$J$11))*MID($I$2:$I$11,{1,2,3,4},1),{1;1;1;1})/1%%+$I$2:$I$11),ROW(A1)*2-2+COLUMN(A1)),4),"0000")
留言
張貼留言