Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Carter68
 
Posts: n/a
Default 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.
  #2   Report Post  
bj
 
Posts: n/a
Default

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.

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.


  #4   Report Post  
terabar
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Worksheet but allow to insert or delete rows Bob L Hilliard Excel Discussion (Misc queries) 2 June 9th 05 03:08 PM
How to delete rows when List toolbar's "delete" isnt highlighted? Linda Excel Worksheet Functions 1 May 26th 05 09:39 PM
How to delete blank rows John Mansfield Excel Discussion (Misc queries) 3 April 28th 05 12:48 AM
Finding Duplicates nospaminlich Excel Worksheet Functions 4 February 6th 05 12:57 AM
Saving to a network share without delete permssions SteveHoot Excel Discussion (Misc queries) 1 January 5th 05 10:50 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"