Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same?

I believe the picture explains what I need, but I can probably supply a test file as well if necessary.


share|improve this question
up vote -1 down vote accepted

Here is your answer, it work for me

Delete duplicate rows from a list in Excel 2010

share|improve this answer
Doesn't work with the example data in my screenshot. – Zach Dec 28 '11 at 19:09
Did you Select Column A by clicking on the A and checking off Unique records only at the Advanced Filter – LowvaPrg Dec 28 '11 at 19:15
Yes. Please try it with the data in my screenshot and let me know if it works for you. – Zach Dec 28 '11 at 19:19
i tried it on Excel 2003 and it didn't do the firs ROW but it did the rest – LowvaPrg Dec 28 '11 at 19:21
@LowvaPrg Link-only answers are a no-no due to possible future link-rot. Please include pertinent information in your answer. – Ƭᴇcʜιᴇ007 Dec 28 '11 at 20:55

I am currently using excel 2010 but This functionality should still be the same.

So basically you want to remove any rows if there is a duplicate in that row's column A correct? If this is the case, highlight everything and go to

Data > Remove Duplicates

You can then select which columns you want to be included in the duplicate search. In your case you only want to select column A. This should solve your problem.

Let me know if this is actually what you need or if imisunderstood anything.

share|improve this answer
I'm in 2003 so I don't have data>remove duplicates. I can get it to filter out duplicates using data>filter>advanced filter, unique records only, but I'm not sure how to copy the results of the filteriing. If you filter on all your data, you can just hit copy since the filtering leaves it selected, but if I only filter on one column, i need to select the other columns, copy, then delete everything and paste back in the filtered data. – Zach Dec 28 '11 at 19:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .