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.
|