F2 下拉{=IFERROR(SMALL(IF(COUNTIF(B:D,ROW(INDIRECT(MIN(B:D)&":"&MAX(B:D))))=0,ROW(INDIRECT(MIN(B$1:D$10)&":"&MAX(B$1:D$10)))),ROW(A1)),"")
限定 1~999 {=IFERROR(SMALL(IF((ROW($1:$999)>=MIN(B:D))*(ROW($1:$999)<=MAX(B:D))*(COUNTIF(B:D,ROW($1:$999))=0),ROW($1:$999)),ROW(A1)),"")
留言
張貼留言