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.