Remove row if duplicate exists in column

Question

How do I remove a row if a duplicate exists in say the first column?

Imagine the following scenario:

You can see that A9 = A12 but notice also that B9 != B11. The current "remove duplicates" function in Excel 2010 only removes the whole row if the whole is identical to the other one.

Any suggestions?

~Solved thanks to pnuts!

possible duplicate of Excel 2007: Remove rows by duplicates in column value — peege
– peege, Commented Jan 15, 2015 at 15:22
In an effort to remove duplicates, this is a Possible Duplicate of this question about removing duplicates, also answered by the person who posted the question. — peege
– peege, Commented Jan 15, 2015 at 15:23
Exactly, I was well aware of the function before posting. Just not of the use pnuts talked about. — kottartillsalu
– kottartillsalu, Commented Jan 16, 2015 at 17:25

RFerwerda · Accepted Answer · 2015-01-15 14:39:27Z

1

I recommend you to read this page: Excel remove rows based on cell value

answered Jan 15, 2015 at 14:39

RFerwerda

1,2772 gold badges10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kottartillsalu Over a year ago

Thanks but pnuts comment actually solved my problem. What I did wrong was that I didn't select the whole sheet when I used the remove duplicate function. I had only selected the first column.

Collectives™ on Stack Overflow

Remove row if duplicate exists in column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related