相连数据 提取相邻数字 (10619)

格式化 C12:F18=SUMPRODUCT(N(COUNTIF(B11:D13,C12)>1))

H12:K18{=IFERROR(SMALL(IF($D12:$F12-$C12:$E12=1,$D12:$F12-{2;-1},IF($D12:$F12-$C12:$E12=-1,ABS(-($D12:$F12+{2;-1})))),COLUMN(A1)),"")