Thread: sorting data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default sorting data

You don't. Sort won't help you with this.

If you're using 2007, there's a Remove Duplicates command in the Data menu.

Another common technique is to insert a helper column and use Countif, as in
=countif(a:a,a1)
and copy down.

Now you know how many times the name has been duplicated, and can filter for
the non-zeros.

Regards,
Fred.

"rdny2" wrote in message
...
How do I sort a large database so I only have duplicate entries in the
last
anme field.