How to remove duplicates from a column

Hi there,

I have a list of about 5,000 words I need to check for duplicates in Excel. At least 5% of them are duplicates. And of course, I need to keep the words correlated with the PPC price, which makes up the other of 2 columns (see attached screenshot).

Is there any very simple way to do this in Excel? All the tutorials I have seen online involve formulas and mathematics and look like hieroglyphics to me. I can't imagine that a program this powerful cannot easily find duplicates.

Thanks!

LL

Originally Posted by dominicb

Good evening LLocal

To remove duplicates without using formulae, VBA, conditional formatting etc, try downloading and installing my add-in via the link below. Once done go to Ultimate > Range > Duplicate Manager.

It will report on, select or delete (all duplicates or subsequent duplicates - ie leave the first of a set intact). You can choose to work on individual duplicates, or you can do the same sort of thing for unique values.

HTH

DominicB

Hey DominicB, that tool works like a charm! The answer to all my problems, and probably many of my future problems! I can't thank you enough.

I figured out a workflow for how to do the task I wanted to do, but the only thing I could not figure out is how to get your tool to highlight both the column that the duplicates are located in (keywords) AND the column associated with it (PPC prices). My work-around is just to highlight or delete the keyowords, expand the data selection to both columns, then sort by the column with keywords, which leaves all the erased keywords at the bottom of the column next to their associated bid prices, at which point I can just delete those entire rows.

Is there any way to have your tool highlight or delete not only the column with the duplicates, but also the column beside it with dollar values?

Either way, this tool will solve my problem. Thanks again.

I too agree, this answered all my problems. (well, the row deletion ones anyway.)

Hi DominicB,
Your add on is fantastic and has many great functions but sadly for deleting duplicates it does not quite match what I am after so instead of starting another thread about duplicates I thought I would post it back here.

The basic problem is that I have redesigned the rota's for work and it needs to check between two sheets that someone's name is not down twice and highlight it in some manner.

Originally I intended to use conditional formatting for this but you can not do it over two sheets or even a range. Any possible alternative ideas?

Is there some form of validation that would work instead? Any ideas would be great or if you need to see an attatched copy or screenshot then just say.

Thanks

Hello Somnophore,

Please send me the file and I would be able to help you. Please send it to [email protected].
Cheers,
Rajashekar

Originally Posted by Somnophore

Hi DominicB,
Your add on is fantastic and has many great functions but sadly for deleting duplicates it does not quite match what I am after so instead of starting another thread about duplicates I thought I would post it back here.

The basic problem is that I have redesigned the rota's for work and it needs to check between two sheets that someone's name is not down twice and highlight it in some manner.

Originally I intended to use conditional formatting for this but you can not do it over two sheets or even a range. Any possible alternative ideas?

Is there some form of validation that would work instead? Any ideas would be great or if you need to see an attatched copy or screenshot then just say.

Thanks

I am having the same problem with duplicate email's, the formula worked great, now, when you delete everything, there are a whole lotta blanks. How do we get rid of the blank cells so that we have one continuous nice looking list? Thanks in advance.

Hi Dominic!

It is SO nice to see an existing thread of plentiful information when you're being stumped with excel.

I have downloaded your Ultimate add-in (which seems like it will prove very useful) and I'm wondering it can help me with my situation.

I have multiple columns of data. I want to remove duplicates from one column while maintaining the associated data in adjacent columns. Also, the one row of the duplicates that I want to keep has to be based on a maximum value in an adjacent column.

Can your add-in help me do this? Any suggestions are greatly appreciated! Thanks in advance.

Originally Posted by dominicb

Good evening LLocal

To remove duplicates without using formulae, VBA, conditional formatting etc, try downloading and installing my add-in via the link below. Once done go to Ultimate > Range > Duplicate Manager.

It will report on, select or delete (all duplicates or subsequent duplicates - ie leave the first of a set intact). You can choose to work on individual duplicates, or you can do the same sort of thing for unique values.

HTH

DominicB

DominicB, this add-in ROCKS! You are awesome. Thank you very very much!!