判斷连号 (10014)

J11{=INDEX($G:$G,SMALL(IF(MMULT(N(MID(G$1:G$20,{2,3,4},1)-MID(G$1:G$20,{1,2,3},1)=1),{1;10;100})={10,101},ROW($1:$20),99),ROW(A1)))&""

L11{=INDEX($G:$G,SMALL(IF(MMULT(N(MID(G$1:G$20,{2,3,4},1)-MID(G$1:G$20,{1,2,3},1)=1),{1;10;100})=0,ROW($1:$20),99),ROW(A1)))&""

N11{=INDEX($G:$G,SMALL(IF(MMULT(N(MID(G$1:G$20&0,{2,3,4,5},1)-MID(G$1:G$20&0,{1,2,3,4},1)=1),{1;10;100;1000})={1,11,100,110},ROW($1:$20),99),ROW(A1)))&""

P11{=INDEX($G:$G,SMALL(IF(MMULT(N(MOD(MID(G$1:G$20,{1,2,3,4},1)*1,2)=0),{1;1;1;1})=3,ROW($1:$20),99),ROW(A1)))&""

R11{=INDEX($G:$G,SMALL(IF(MMULT(N(MOD(MID(G$1:G$20,{1,2,3,4},1)*1,2)=1),{1;1;1;1})=3,ROW($1:$20),99),ROW(A1)))&""

T11{=INDEX($G:$G,SMALL(IF(MMULT(N(MOD(MID(G$1:G$20,{1,2,3,4},1)*1,2)=1),{1;1;1;1})=2,ROW($1:$20),99),ROW(A1)))&""