Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) |