请教怎么删掉一列中相同的两个数

dudulily

<p>&nbsp; 如例子当中第一列中数据若相同把他们都删掉，</p>

丁紫

<p>用排序吧，把一列数据排序后相同的就会在一起，然后在删除！这是我的思路，高手们肯定还有别的方法！</p>

希哲

用高级筛选

cici8582

<p>查找替换</p>

蛮蛮猫

<p>高级筛选是最简单的办法</p><p>数据透视表和分类汇总也不失为好的办法</p><p>加个辅助列用COUNTIF也是个简单的办法</p><p>2007版里可以直接操作</p><p>另外还有N多函数法</p>

[此贴子已经被作者于2008-8-12 11:06:35编辑过]

蛮蛮猫

<p>楼主把这个贴子发在这里,是想要找函数解法是吗?</p><p>{=OFFSET($A$1,MATCH(,COUNTIF($C$1:C1,$A$2:$A$24),),)}<br/><br/>=LOOKUP(1,1/NOT(COUNTIF($C$1:C1,$A$2:$A$24)),$A$2:$A$24)<br/><br/>{=IF(SUM(1/COUNTIF($A$1:$A$24,$A$1:$A$24))&gt;=ROW(A1),OFFSET($A$1,SMALL(IF(MATCH($A$1:$A$24,$A$1:$A$24,0)=ROW($A$1:$A$24),ROW($A$1:$A$24)),ROW(A1))-1,),"")}<br/><br/>{=INDEX(A:A,SMALL(IF(FREQUENCY(MATCH($A$2:$A$24,$A$2:$A$24,),MATCH($A$2:$A$24,$A$2:$A$24,)),ROW($A$2:$A$24),65536),ROW(A1)))&amp;""} <br/><br/>{=INDEX($A$2:$A$24,SMALL(IF(MATCH($A$2:$A$24,$A$2:$A$24,)=ROW($A$2:$A$24)-1,ROW($A$2:$A$24)-1,65536),ROW(A1)))} <br/></p>

d

??????/

hai

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>蛮蛮猫</i>在2008-8-12 11:06:00的发言：</b><br/><p>楼主把这个贴子发在这里,是想要找函数解法是吗?</p><p>{=OFFSET($A$1,MATCH(,COUNTIF($C$1:C1,$A$2:$A$24),),)}<br/><br/>=LOOKUP(1,1/NOT(COUNTIF($C$1:C1,$A$2:$A$24)),$A$2:$A$24)<br/><br/>{=IF(SUM(1/COUNTIF($A$1:$A$24,$A$1:$A$24))&gt;=ROW(A1),OFFSET($A$1,SMALL(IF(MATCH($A$1:$A$24,$A$1:$A$24,0)=ROW($A$1:$A$24),ROW($A$1:$A$24)),ROW(A1))-1,),"")}<br/><br/>{=INDEX(A:A,SMALL(IF(FREQUENCY(MATCH($A$2:$A$24,$A$2:$A$24,),MATCH($A$2:$A$24,$A$2:$A$24,)),ROW($A$2:$A$24),65536),ROW(A1)))&amp;""} <br/><br/>{=INDEX($A$2:$A$24,SMALL(IF(MATCH($A$2:$A$24,$A$2:$A$24,)=ROW($A$2:$A$24)-1,ROW($A$2:$A$24)-1,65536),ROW(A1)))} <br/></p></div><p>高手猫!</p>

hlh1557760

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>蛮蛮猫</i>在2008-8-12 11:06:00的发言：</b><br/><p>楼主把这个贴子发在这里,是想要找函数解法是吗?</p><p>{=OFFSET($A$1,MATCH(,COUNTIF($C$1:C1,$A$2:$A$24),),)}<br/><br/>=LOOKUP(1,1/NOT(COUNTIF($C$1:C1,$A$2:$A$24)),$A$2:$A$24)<br/><br/>{=IF(SUM(1/COUNTIF($A$1:$A$24,$A$1:$A$24))&gt;=ROW(A1),OFFSET($A$1,SMALL(IF(MATCH($A$1:$A$24,$A$1:$A$24,0)=ROW($A$1:$A$24),ROW($A$1:$A$24)),ROW(A1))-1,),"")}<br/><br/>{=INDEX(A:A,SMALL(IF(FREQUENCY(MATCH($A$2:$A$24,$A$2:$A$24,),MATCH($A$2:$A$24,$A$2:$A$24,)),ROW($A$2:$A$24),65536),ROW(A1)))&amp;""} <br/><br/>{=INDEX($A$2:$A$24,SMALL(IF(MATCH($A$2:$A$24,$A$2:$A$24,)=ROW($A$2:$A$24)-1,ROW($A$2:$A$24)-1,65536),ROW(A1)))} <br/></p></div><p></p>天，好长，都不知道怎么做了，工作中每天都要删除重值，但我用了最笨的方法IF

wuzhouxing

<p>在增加一个方法</p><p>=IF(SUM(N(COUNTIF($D$1:D1,$A$2:$A$15)=0)),INDEX($A$2:$A$15,MATCH(,COUNTIF($D$1:D1,$A$2:$A$15),)),"")</p>