最小至最大 缺少數字 (13482)

D2{=IFERROR(SMALL(IF(COUNTIF(B:B,ROW(INDIRECT(MIN(B$2:B$16)&":"&MAX(B$2:B$16))))=0,ROW(INDIRECT(MIN(B$2:B$16)&":"&MAX(B$2:B$16)))),ROW(A1)),"")



留言