OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

delete duplicate rows

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
grantfuller
Newbie
Newbie


Joined: 12 Jun 2005
Posts: 2
Location: Victoria, BC

PostPosted: Thu Dec 21, 2006 11:34 am    Post subject: delete duplicate rows Reply with quote

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
View user's profile Send private message Visit poster's website
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Dec 21, 2006 12:54 pm    Post subject: Re: delete duplicate rows Reply with quote

grantfuller wrote:
I have searched for days


Where have you searched? Searching this forum for "delete" and "duplicate" gives some suggestions.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Dec 21, 2006 1:50 pm    Post subject: Re: delete duplicate rows Reply with quote

Save as a CSV, then use freeware CSVed.

David.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu Dec 21, 2006 2:23 pm    Post subject: Reply with quote

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
View user's profile Send private message
BillP
Super User
Super User


Joined: 07 Jan 2006
Posts: 2703

PostPosted: Thu Dec 21, 2006 3:04 pm    Post subject: Reply with quote

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
View user's profile Send private message
grantfuller
Newbie
Newbie


Joined: 12 Jun 2005
Posts: 2
Location: Victoria, BC

PostPosted: Thu Dec 21, 2006 5:11 pm    Post subject: Thanks all Reply with quote

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
View user's profile Send private message Visit poster's website
madan712
Newbie
Newbie


Joined: 19 Apr 2009
Posts: 1

PostPosted: Sun Apr 19, 2009 1:04 am    Post subject: Check Solution Reply with quote

Hi,

Get Solution here.. for deleting duplicate rows in Oracle and MS SQL

http://simpleandeasycodes.blogspot.com/2009/04/dbms-remove-duplicate-entries-from.html
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group