Excel教程下载和软件下载中心,Microsoft技术社区联盟成员,全球领先的Excel门户,Office技术培训的最佳社区

移除重复的Excel列表(和区域)记录

2014-03-26  作者:ExcelHome  阅读:

译者:fanjy  来源http://blogs.msdn.com/excel
发表于:2006年7月7日

Tables Part 6: Removing duplicates from tables (and ranges) of data
列表(第6部分):移除重复的列表(和区域)记录

Being able to remove duplicate rows of information from a table of data is a request we hear fairly often from our customers (and one of the top questions in the comments in this blog). Some users know that this capability exists in Excel today; unfortunately it is buried under advanced filter settings and it’s not terribly easy to use. So we set out in Excel 12 to build a better interface specifically for this task so that any user could easily remove unnecessary data from their spreadsheet.
我们经常听到的一个客户需求是能够从列表中移除重复的数据行(这也是在博客中提出的最多的问题之一)。一些用户知道在目前版本的Excel中已有这个功能,遗憾的是它隐藏在高级筛选设置中且不易使用(译者注:即高级筛选中选择不重复的记录选项)。于是,我们在Excel 12中将这项功能设置在了一个更友好的专门的界面中,以便于任何用户都能容易地从电子表格中移除不需要的记录。

Remove duplicates can be found in two places in Excel 12, on the Data ribbon as well as the Table ribbon (just like sort and filters, it’s not necessary to have a table in order to use this feature). To use the feature, a user simply has to select the data they want to examine for duplicates and press the “Remove Duplicates” button. This will bring up a dialog that looks like this:
在Excel 12中移除重复记录的功能被设置在Data ribbon和Table ribbon中(就像排序和筛选一样,不需要设置专门的列表框来使用这个功能)。要使用这个功能,用户只需简单地选择想检查的记录,按下”Remove Duplicates”按钮后,出现下图所示的对话框:

You’ll notice that all my column headers appear in the dialog. To remove duplicates, just select the columns that Excel should use to evaluate duplicates. For example, in my table above I want to remove all duplicate rows where the first name is the same and the last name is the same. In other words, if there is more than one row where FirstName = David and LastName = Gainer then the extra duplicate rows will be removed. So my table which looked like this:
你将看到列表中所有的列标题都出现在对话框中。要移除重复的记录,只需选择这些列标题,Excel将自动筛选除去(满足条件的)重复的记录。例如,在上表中,若要移除所有第一个名字和最后一个名字都相同的记录,即如果第一个名字为David且第二个名字为Gainer的记录多于一条,那么将移除多余的记录行。如下图所示的列表:

Now looks like the following after I remove duplicates.
在移除重复的记录后的列表如下:

Note that remove duplicates physically removes data from your spreadsheet. It does not hide rows. You can, of course, back out (undo) of remove duplicates if you make a mistake. If you wanted to first take a look at the duplicate values, you could use the new “Highlight Duplicate Values” feature that we have added to conditional formatting to do so.
注意,移除重复记录功能会从你的电子表格中彻底删除记录,而不是隐藏行。当然,如果你发现操作错误,你可以撤销刚才的移除重复记录操作。如果你想先看看这些重复记录值,可以使用已添加到条件格式中的”Highlight Duplicate Values”新功能。

In my next post I will finish up table-specific features by reviewing the work we did with table styles.
在下篇文章中,我将介绍列表样式,并结束对列表特殊功能的介绍。

Published Friday, November 04, 2005 3:13 PM by David Gainer

注:本文翻译自http://blogs.msdn.com/excel,原文作者为David Gainer(a Microsoft employee),Excel home授权转载。严禁任何人以任何形式转载,违者必究。

非常感谢Kevin的帮助和指导!

转载请注明来源"ExcelHome"并保留原文链接。
固定链接:http://www.excelhome.net/lesson/article/excel/598.html
分享到:
Copyright 1999 - 2017 Excel Home.All Rights Reserved.
本站特聘法律顾问:徐怀玉律师 李志群律师   沪ICP备11019229号

沪公网安备 31011702000001号

征信