[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


delete row if some member is duplicate in excel

Posted on 2011-02-12
Medium Priority
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
Question by:teera
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
LVL 42

Expert Comment

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.

LVL 42

Expert Comment

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



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

LVL 42

Expert Comment

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!

LVL 42

Accepted Solution

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



Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

656 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