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

Check for duplicate rows

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


Joined: 27 Jul 2010
Posts: 1

PostPosted: Tue Jul 27, 2010 8:43 pm    Post subject: Check for duplicate rows Reply with quote

Hi,
I'm making an e-mail list in Calc and I just want to make sure there are no duplicate rows under the Email field.

Is there a quick and easy way to do this?

Cheers
_________________
Kosta Kondratenko
http://www.headstudios.com.au << see me on video there!
Back to top
View user's profile Send private message Send e-mail Visit poster's website
abcuser
General User
General User


Joined: 27 Jul 2010
Posts: 15

PostPosted: Tue Jul 27, 2010 11:04 pm    Post subject: Reply with quote

1. write mails from A1:A3:
my@mail.com
you@mail.com
you@mail.com
2. mark column A and click on "Sort Ascending" button to sort column.
3. in field B1 write formula: =IF(A1=A2;"Duplicate";"OK")
4. copy/paste the formula to B2:B3.[/code]
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