二數字之間連續 緊接顯示 (11239)


C2{=IFERROR(RIGHT(SMALL(IF(RIGHT(A$2:A$7,4)-LEFT(A$2:A$7,4)+1>=COLUMN(A:I),ROW($2:$7)*10^8+LEFT(A$2:A$7,4)+COLUMN(A:I)-1),ROW(A1)),4)*1,"")


留言