| View previous topic :: View next topic |
| Author |
Message |
grantfuller
Newbie
Joined: 12 Jun 2005
Posts: 2
Location: Victoria, BC
|
 Posted: Thu Dec 21, 2006 11:34 am Post subject: delete duplicate rows |
 |
|
| I have searched for days for an answer to what I thought would be a simple thing to find. I have a list of 300 names and I want to eliminate any duplication. Is there a way to find and delete duplicate rows? |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Thu Dec 21, 2006 12:54 pm Post subject: Re: delete duplicate rows |
|
|
| grantfuller wrote: | | I have searched for days |
Where have you searched? Searching this forum for "delete" and "duplicate" gives some suggestions. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Dec 21, 2006 1:50 pm Post subject: Re: delete duplicate rows |
|
|
Save as a CSV, then use freeware CSVed.
David. |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Thu Dec 21, 2006 2:23 pm Post subject: |
|
|
This formula will tell you whether any names are duplicated, taking column A as the location of your list:
=COUNTIF($A$1:$A$300;$A1)
Fill down. When the formula returns a number greater than 1, remove a duplicate and recalculate.
_________________
search forum by month |
|
| Back to top |
|
|
BillP
Super User
Joined: 07 Jan 2006
Posts: 2702
|
| Posted: Thu Dec 21, 2006 3:04 pm Post subject: |
|
|
| Have you tried the standard filter (Data > Filter > Standard filter)? It has a "No duplicate" option and an option to copy the filtered list to another cell range. |
|
| Back to top |
|
|
grantfuller
Newbie
Joined: 12 Jun 2005
Posts: 2
Location: Victoria, BC
|
| Posted: Thu Dec 21, 2006 5:11 pm Post subject: Thanks all |
|
|
| I think the suggestion by BillP is the one I am looking for. I am still studying the novice stages of managing this stuff. Merry Christmas! |
|
| Back to top |
|
|
madan712
Newbie
Joined: 19 Apr 2009
Posts: 1
|
|
| Back to top |
|
|
|
