Excel往除重复项的几种常用技能(国外英语资料).doc

Excel去除重复项的几种常用技巧Excel removes several common techniques for repeating itemsAt work, there are often times when you need to clean up the original record list to get rid of some of the duplicates. So-called duplicates, usually refers to some records in various fields have the same content (longitudinal called field, transverse, called record), such as in the figure below the third row data record and fifth row data is completely the same two records, in addition there are 6 line and the tenth is a set of the same records.?In other scenarios, the user may wish to identify and eliminate some fields of the same but is not quite repetitive duplicates, such as in the figure below 7 rows and rows of [name] 12 field content is the same, but the content of the other fields are not completely the same.?Above the two duplicates of the type is different, also a slight difference on weed out the implementation of the operation, but there is no much difference in essence, can learn from each other. Here, take the two scenarios, introducing several commonly used techniques for removing duplicate items.1, delete duplicate itemsThe ability to delete duplicate items is a new addition to the Excel 2007 version, so it applies to Excel 2007 and its subsequent releases.Cell activity to locate in the list of data, and, in turn, click on the area [data] - [delete duplicates], [delete duplicates] dialog box will appear.The dialog box asks the user to select the column (field) where the data is repeated. Suppose we define a duplicate item as the exact same record for all fields, and then check all the columns here. And if just defines a column of the same record as duplicates, such as the article mentioned in the beginning the second scenario, then you just need to check the column. ?After check all the columns, click [sure] button, you will automatically get deleted after duplicates data list, eliminate the guild automatically by the bottom of the data line fill blank, but will not affect o