CODEWITHSUNDEEP
excelduplicates
kottartillsalu
kottartillsalu

Reputation: 90

Remove row if duplicate exists in column

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!

Upvotes: 0

Views: 2949

Answers (1)

RFerwerda
RFerwerda

Reputation: 1277

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

Upvotes: 1

Related Questions