Solved

delete row if some member is duplicate in excel

Posted on 2011-02-12
5
206 Views
Last Modified: 2012-06-27
column a is email address and column b is name of email address column c is address

if  a some member of column a is duplicate I want to delete the row that duplicate keep only one row how can i write marco in excel
0
Comment
Question by:teera
  • 5
5 Comments
 
LVL 41

Expert Comment

by:dlmille
ID: 34881010
Do you need a macro?  There are ways to do this manually and very quick. Let me know.

Just create a column D with this formula, assuming you have headers, we'll put this in row 2

[D2] = countif(A:A,A2)

this formula will tell you if there is a duplicate , as it will be > 1

Then turn on data filters, filter for everything not = 1 and select the resulting rows and delete them.

Let me know if you MUST have a macro and I can provide.

Dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34881022
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34881024
Finally, here's a link to a macro (see deleting duplicate rows):

http://www.cpearson.com/excel/deleting.htm

Dave

Let me know if you need assistance on any of these 3 methods.

Dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34881027
Oh - one more - in Excel hit F1 for help.  Look up duplicate, then select 10 ways to clean your data - there's a section on a couple steps to delete duplicate rows..


Have fun!

Dave
0
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 34884514
I was documenting past tips I participated in.   Here's one more set of options on deleting duplicate rows...

http:Q_26750772.html

Dave
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now