Delete duplicates
 

How do I delete duplicates from a spreadsheet and keep only the unique
records? If I have the name "Smith, 123 Lane, City" listed 2 times in a
spreadsheet, I want to delete both of the records and not keep either record.

one way to do it is to add a helper column
if there are three columns with information
in D1 enter
=if(and(countif(A:A,A1)1,countif(B:B,B1)1,counti f(C:C,C1)1),1,0)
copy down to the end of your data.
sort columns A<B<C<D by column D and delete all the rows with 1 in Column D.

"Carter68" wrote:

How do I delete duplicates from a spreadsheet and keep only the unique
records? If I have the name "Smith, 123 Lane, City" listed 2 times in a
spreadsheet, I want to delete both of the records and not keep either record.

DataFilterAdvanced filterCopy to another location and unique records only.

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben Excel MVP

On Tue, 14 Jun 2005 12:41:18 -0700, "Carter68"
wrote:

How do I delete duplicates from a spreadsheet and keep only the unique
records? If I have the name "Smith, 123 Lane, City" listed 2 times in a
spreadsheet, I want to delete both of the records and not keep either record.

If u don't want to use formulars u can do this using the Advance Filter
option. Data Filter Advance filter, then select the appropriate
options and ensure that the check box at the bottom "Unique records
only" is flagged.

Although this will not delete them u can "Copy to another location" and
then delete the original one later. I usually use this option to refer
back to the original list later if the need arises.

Cheers.


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=379145