How to remove duplicates from a column
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.
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.
Last edited by dominicb; 02-02-2007 at 01:54 PM.
Please familiarise yourself with the rules before posting. You can find them here.
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.
Originally Posted by dominicb
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.
Thanks for the positive feedback - always nice to hear users' thoughts.
If you want to delete whole rows, try this.
Select your range in the column containing duplicates.
Ultimate > Range > Duplicate Manager, say, Select all Subsequent Duplicates
This will highlight subsequents only.
Right click on any of the selected cells
Select Entire Row and click OK.
I too agree, this answered all my problems. (well, the row deletion ones anyway.)
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.
Mark the Duplicates
Please send me the file and I would be able to help you. Please send it to email@example.com.
Originally Posted by Somnophore
duplicate email listings
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.
Good morning lovely
...and welcome to the forum!!
Next time you ask a question you stand far more chance of a quick reply if you open a new thread of your own.
Just for the record, though, if you're using my utility see the steps provided in post 5 of this thread. That, I believe, gives you the answer you're looking for.
How to remove duplicates via max values from adjacent column
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.
Re: How to remove duplicates from a column
DominicB, this add-in ROCKS! You are awesome. Thank you very very much!!
Originally Posted by dominicb
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1