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

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.

Hi,

I'm not clear on what you want. It sounds like you want to remove all the
non-duplicates from your data and keep the duplicates. So if you have 10,000
names and two have the last name Smith, you want to end up with two rows of
data, everything else deleted?

There is also the question of what you mean by duplicates. In the following
example are there 2 or 3 duplicates?

Smith
Jones
Smith
Smith

What version of Excel are you using?
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"rdny2" wrote:

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

On Jan 24, 10:29 pm, Shane Devenshire
wrote:
Hi,

I'm not clear on what you want. It sounds like you want to remove all the
non-duplicates from your data and keep the duplicates. So if you have 10,000
names and two have the last name Smith, you want to end up with two rows of
data, everything else deleted?

There is also the question of what you mean by duplicates. In the following
example are there 2 or 3 duplicates?

Smith
Jones
Smith
Smith

What version of Excel are you using?
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

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

Have a look at Pointy Haired Dilbert blog:

Extracting Unique, Duplicate and Missing Items using Formulas,
http://chandoo.org/wp/2008/11/06/uni...ms-excel-help/.
Maybe this helps you.
Cheers Michael