+ Reply to Thread
Results 1 to 4 of 4

delete duplicates in one collumn

  1. #1
    Registered User
    Join Date
    10-02-2015
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    3

    delete duplicates in one collumn

    Hello everybody, I need a little help to make the job done.

    Ive got columns A and B, in column A Ive got 10000 cells and in B 200, but now i need to compare this two columns and delete duplicates in column A.
    Ive figure it out how to highlight cells in column A which are identical with cells in column B. In conditional formatting I used formula =countif($B:$B,A1)=1, is there any addition to make highlighted cells to disappear?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,803

    Re: delete duplicates in one collumn

    You've posted this in the Formulas sub-forum, but a formula cannot delete data. What you can do is use a formula in another column which will extract unique values from column A, and then if you fix those values you will be able to delete the original column A.

    If this is a one-off requirement, you can also use Advanced Filter on the Data menu which will allow you to get unique values with a few clicks of the mouse.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-02-2015
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    3

    Re: delete duplicates in one collumn

    Of course, that idea with extracting is simple and really good Thanks.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,803

    Re: delete duplicates in one collumn

    You're welcome.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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