多范圍內的數字 不出現 (12392)

(2007版) E2{=IFERROR(IF(ROW(A1)=1,"",",")&SMALL(IF(MMULT((ROW($1:$99)<TRANSPOSE(A$2:A$9))+(ROW($1:$99)>TRANSPOSE(B$2:B$9)),ROW(1:8)^0)=8,ROW($1:$99)),ROW(A1))&E3,"")



留言