Excel:I've a list of 230k tel numbers.Most are duplicates.I need 2 sort them in order with the most recurring?

Question

Excel:I've a list of 230k tel numbers.Most are duplicates.I need 2 sort them in order with the most recurring?

Answer 1

Your data in column A. In column B cell B1 type =countif(A:A,A1). Copy formula down as far as is required. Select both columns and sort descending on column B.

If you wish to delete the duplicates type in C1 =if(exact(A!,A2),"Duplicate",""). Also copy down as far as is required. Filter on column C>Duplicate. Delete the filtered rows. Will leave 1 instance of each number. Select the 3 columns and resort on Column A ascending. HTH

Answer 2

Go up to sort and click it it gives numerous options of what to do

Sort ascending Sort Descending plus by letter or number