移除重復(fù)的Excel列表(和區(qū)域)記錄

移除重復(fù)的Excel列表(和區(qū)域)記錄

譯者：fanjy? 來(lái)源：http://blogs.msdn.com/excel 發(fā)表于：2006年7月7日

Tables Part 6: Removing duplicates from tables (and ranges) of data 列表(第6部分)：移除重復(fù)的列表(和區(qū)域)記錄

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. 我們經(jīng)常聽(tīng)到的一個(gè)客戶需求是能夠從列表中移除重復(fù)的數(shù)據(jù)行(這也是在博客中提出的最多的問(wèn)題之一)。一些用戶知道在目前版本的Excel中已有這個(gè)功能，遺憾的是它隱藏在高級(jí)篩選設(shè)置中且不易使用(譯者注：即高級(jí)篩選中選擇不重復(fù)的記錄選項(xiàng))。于是，我們?cè)贓xcel 12中將這項(xiàng)功能設(shè)置在了一個(gè)更友好的專門的界面中，以便于任何用戶都能容易地從電子表格中移除不需要的記錄。

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中移除重復(fù)記錄的功能被設(shè)置在Data ribbon和Table ribbon中(就像排序和篩選一樣，不需要設(shè)置專門的列表框來(lái)使用這個(gè)功能)。要使用這個(gè)功能，用戶只需簡(jiǎn)單地選擇想檢查的記錄，按下”Remove Duplicates”按鈕后，出現(xiàn)下圖所示的對(duì)話框：

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: 你將看到列表中所有的列標(biāo)題都出現(xiàn)在對(duì)話框中。要移除重復(fù)的記錄，只需選擇這些列標(biāo)題，Excel將自動(dòng)篩選除去(滿足條件的)重復(fù)的記錄。例如，在上表中，若要移除所有第一個(gè)名字和最后一個(gè)名字都相同的記錄，即如果第一個(gè)名字為David且第二個(gè)名字為Gainer的記錄多于一條，那么將移除多余的記錄行。如下圖所示的列表：

Now looks like the following after I remove duplicates. 在移除重復(fù)的記錄后的列表如下：

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. 注意，移除重復(fù)記錄功能會(huì)從你的電子表格中徹底刪除記錄，而不是隱藏行。當(dāng)然，如果你發(fā)現(xiàn)操作錯(cuò)誤，你可以撤銷剛才的移除重復(fù)記錄操作。如果你想先看看這些重復(fù)記錄值，可以使用已添加到條件格式中的”Highlight Duplicate Values”新功能。

In my next post I will finish up table-specific features by reviewing the work we did with table styles. 在下篇文章中，我將介紹列表樣式，并結(jié)束對(duì)列表特殊功能的介紹。

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

非常感謝Kevin的幫助和指導(dǎo)!

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請(qǐng)聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請(qǐng)聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時(shí)內(nèi)刪除侵權(quán)內(nèi)容。