excel中若何检查重复的数据(国外英语资料).doc

excel中如何检查重复的数据 How do you check duplicate data authors in excel: geo Step 1: select all areas where duplicate data may exist Step 2: format -- conditional format -- select formula Step 3: enter: = countif (area, A1) 1 For example: = countif ($A: $A: $F, A1) 1 represents the check in column A to the F column area, A1 is its own cell, and the system will be copied for each cell Step 4: format - - - choose a different color Student student number and result in the design table of Excel, sometimes require data can not be repeated, such as student number, telephone number, but we often occurs when the input entry repeat, especially the teacher individual not serious, cause when we publish the final result to a lot of problems, the same student id actually corresponds to a few students, how to check the uniqueness of the data and the data deduplication. After the study, three methods were found. ?? Methods a ?? If be in A1 to A25 cell area is student id, student id to check for repeat, is within the B2 cell input formula = countif (A: A, A2), then select B2 cell, dragging down, until B25 in column B, has appeared on the left side of the student number, the number of occurrences of the duplicate data manually delete it. ?? Method 2 ?? Select A2 to A25, click format - conditional format, select formula in the conditional 1 column, and enter countif (A, A2) 1 in the formula bar. Then, in the cell format selected pattern, set the pattern color into red, after click ok, have repeatedly student id cell shown in red. Manually delete duplicate data. ?? Methods three ?? A friend who likes to program VBA can use the method of writing VBA code, allowing the computer to automatically find duplicate data and automatically delete duplicate rows. The details of the process vary, as follows: Private Sub tj () ? Dim I As Integer???? ? / / define I for integer variables ? Dim j? As an Integer??? ? / / define J as integer variable? ? Sheets ( Sheet1 ).select. / / select the sheet1 wor