...单元格存放10个随机的个位数字,想输出10个数字中不存在的数字...答:D2=IF(SMALL(IF(COUNTIF($B$2:$B$11,$B$2:$B$11)=1,$B$2:$B$11,4^8),ROW(I1))=4^8,"",SMALL(IF(COUNTIF($B$2:$B$11,$B$2:$B$11)=1,$B$2:$B$11,4^8),ROW(I1)))数组公式 E2=IF(ROW(E1)>5,"",IF(ROW(E1)<=SUMPRODUCT(($C$2:$C$11<>"")*1),...
excel表格 数值范围内筛选未出现的数字答:I2=IF(SMALL(IF(COUNTIF(C$2:C$16,ROW($1:$10)),11,ROW($1:$10)),ROW(A1))>10,"",SMALL(IF(COUNTIF(C$2:C$16,ROW($1:$10)),11,ROW($1:$10)),ROW(A1)))数组公式向下向右复制 数组公式,公式输完后,光标放在公式编辑栏同时按下CTRL+SHIFT+回车键,使数组公式生效 ...