0

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.

Help

Improve this question

2 Answers 2

Reset to default
-1

Here is your answer, it work for me

Delete duplicate rows from a list in Excel 2010

Improve this answer
11
  • Doesn't work with the example data in my screenshot.
    – Zach
    Dec 28, 2011 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, 2011 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, 2011 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, 2011 at 19:21
  • 2
    @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, 2011 at 20:55
1

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.

Improve this answer
1
  • 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, 2011 at 19:48

You must log in to answer this question.

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