+ Reply to Thread
Results 1 to 12 of 12

How to remove duplicates from a column

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    3

    Smile 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
    Attached Images Attached Images

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    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
    Last edited by dominicb; 02-02-2007 at 01:54 PM.
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    Take a look at Chip's solution ...
    http://www.cpearson.com/excel/duplicat.htm#Replacing
    HTH
    Carim


    Top Excel Links

  4. #4
    Registered User
    Join Date
    01-31-2007
    Posts
    3

    Talking

    Quote 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.

  5. #5
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi LLocal

    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 Delete...
    Select Entire Row and click OK.

    HTH

    DominicB

  6. #6
    Registered User
    Join Date
    04-06-2004
    Posts
    27

    thanks

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

  7. #7
    Registered User
    Join Date
    03-02-2007
    Posts
    1

    Deleting Duplicates

    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

  8. #8
    Registered User
    Join Date
    04-11-2008
    Posts
    2

    Mark the Duplicates

    Hello Somnophore,

    Please send me the file and I would be able to help you. Please send it to ebusiness_specialist@yahoo.com.
    Cheers,
    Rajashekar



    Quote 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

  9. #9
    Registered User
    Join Date
    04-11-2008
    Posts
    3

    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.

  10. #10
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    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.

    HTH

    DominicB

  11. #11
    Registered User
    Join Date
    04-29-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to remove duplicates via max values from adjacent column

    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.

  12. #12
    Registered User
    Join Date
    02-13-2009
    Location
    Silicon Valley
    MS-Off Ver
    Excel 2003 SP3
    Posts
    1

    Re: How to remove duplicates from a column

    Quote Originally Posted by dominicb View Post
    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!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1