有奖练习:删除重复数据,保留最新一条记录

小笨蛋

<br/><div class="msgheader">QUOTE:</div><div class="msgborder"><font color="#ff00ff"><strong>请用回复贴上交答案,前5名每人15个BB!</strong></font></div><div class="msgheader">QUOTE:</div><div class="msgborder"><font color="#ff00ff"><strong>请看附件说明,技巧+函数!</strong></font></div><div class="msgheader">QUOTE:</div><div class="msgborder"><strong><font color="#ff00ff">说明补充,是在原数据删除,条件是B列!</font></strong></div><div class="msgheader">QUOTE:</div><div class="msgborder">发现和关题,段位题相冲!<strong><font color="#ff00ff"></font></strong></div>

[此贴子已经被作者于2008-7-14 3:15:00编辑过]

MXQCHINA

<p>

游客，如果您要查看本帖隐藏内容请回复

</p><br/>

wayy

<p>只知道高级筛选后再用函数</p>[em04]

wayy

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>MXQCHINA</i>在2008-7-13 18:15:00的发言：</b><br/><p></p><br/></div><p></p>学习了。

一剑惊心

<p>技巧?函数?</p>

wayy

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>一剑惊心</i>在2008-7-13 18:34:00的发言：</b><br/><p>技巧?函数?</p></div><p></p>技巧+函数[em05]

小笨蛋

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>MXQCHINA</i>在2008-7-13 18:15:00的发言：</b><br/><p></p></div>&nbsp;楼上用的不只一个单元格吧!

188cdma

[em01]

188cdma

<table cellspacing="0" cellpadding="0" width="231" border="0" xstr="" style="WIDTH: 173pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="87" style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2784;"></col><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" width="87" height="22" xnum="39489" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 65pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="MingLiU">2008-2-11</font></td><td class="xl23" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">VVV</font></td><td class="xl22" width="72" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">200</font></td></tr></tbody></table>这条记录跟哪条记录重复了 最后结果怎么没有了呢

yaoxuejian

<p>到时候看答案</p>