sorting data

  • Thread starter Thread starter rdny2
  • Start date Start date
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?
 
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
Click to expand...

Have a look at Pointy Haired Dilbert blog:

Extracting Unique, Duplicate and Missing Items using Formulas,
http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/.
Maybe this helps you.
Cheers Michael
 
Back
Top