Delete duplicates

[Guest]

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.

 

[Guest]

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,countif(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.

 

[Gord Dibben]

Data>Filter>Advanced filter>Copy to another location and unique records only.

For more on this see Debra Dalgleish's site

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


Gord Dibben Excel MVP

 

[terabar]

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

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

Cheers