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.
Here is your answer, it work for me
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.