Now the hands of a large number of users Excel format telephone numbers of resources, the problem is selected to repeat the numbers, how should it operate?

Access to Excel, click menu – Data – Filter – Advanced Filter.

In the “Advanced Filter” dialog box, “a list of regional” and “the conditions of the region” are telephone numbers where the scope, at the same time to “choose not to repeat the record” in front of the box marked “√”, click “OK” .
And then select the entire table and copy to another empty table, the contents of the new table on the line with your request and in the end, delete the original table, OK.

In addition, we also can use the formula all the way out to repeat the phone tag. A hypothesis as a phone number, you can set out in the B input to the other blank out the formula “= IF (COUNTIF (A: A, A: A)> 1,” duplication “,” No Repeat “)”, and then down Copy this formula. To sort out on the B (descending), repeat the number on the display in front of.