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