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.