问题标题：
在A1到A14单元数据2,4,5,6,4,8,4,1,3,4,5,3,7,3:提取1,2,3,4,5,6,7,8不重复与重复的数,保存在A16单元格后面.我将公式改了一下,但不知那问题就是不行；=IF(SMALL(IF(COUNTIF(A1:A14,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7
问题描述：
在A1到A14单元数据2,4,5,6,4,8,4,1,3,4,5,3,7,3:提取1,2,3,4,5,6,7,8不重复与重复的数,保存在A16单元格后面.我将公式改了一下,但不知那问题就是不行；=IF(SMALL(IF(COUNTIF(A1:A14,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),COLUMN(A16))=99,"",SMALL(IF(COUNTIF(A1:A14,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),COLUMN(A16))).另一个是在B1到B7.1234511和C1到C7有1345685数怎样将相同数1345选出保存在C9以下单元格里.IF(SMALL(IF(COUNTIF($B1:$B7,{0,1,2,3,4,5,6,7,8,9})*COUNTIF($C1:$C7,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),COLUMN(B1))=99,"",SMALL(IF(COUNTIF($C1:$C7,{0,1,2,3,4,5,6,7,8,9})*COUNTIF($C1:C7,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),COLUMN(C1))).两条公式不知那里出了》》.能否帮忙看下.
何昱回答：
A1:A14的做法：在任意单元格输入=IF(SMALL(IF(COUNTIF(A$1:A$14,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),ROW(A1))=99,"",SMALL(IF(COUNTIF(A$1:A$14,{0,1,2,3,4,5,6,7,8,9}),{0,1,2,3,4,5,6,7,8,9},99),...
查看更多
