連續四數字 顯現 (9985)

C2=IF((0&C1)+1=A2,A2,IF(ISNA(MATCH(A2+3,A3:A9,)),"",REPT(A2,MATCH(A2+3,A3:A9,)=3)))

D1=REPT(A1,ISNUMBER(FIND(1111,MMULT(SIGN(COUNTIF(A$1:A9,A1+{-3,-2,-1,0,1,2,3})),10^ROW($1:$7))))*(A1<>A2))

E3=IF(OR(VAR(A1:A3)=1,VAR(A2:A4)=1,VAR(IF({1;1;1},A3:A5))=1),A3,"")

另解=IF(MODE(A1:A4-{0;1;2;3},0,0,0,0),A1,IF(A1-(0&INDIRECT("R[-1]C",))=1,A1,""))