delete row if some member is duplicate in excel

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
teeraAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
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
 
dlmilleCommented:
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
 
dlmilleCommented:
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
 
dlmilleCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.