excel根据数据范围迅速将单元格数据筛选得出剩余数据?答:1-10可以用公式计算剩余数的1-9连在一起10在最后用逗号分隔(如a1剩余数是24689,10),如果这样可以,则a3=SUBSTITUTE(SUM(IF(ISERROR(FIND(","&ROW($1:$9)&",",","&A1&",")),ROW($1:$9)*10^(9-ROW($1:$9))),0,"")&IF(COUNT(FIND(10,A1))=0,",10","")数组公式,...
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+回车键,使数组公式生效 ...