+ Reply to Thread
Results 1 to 5 of 5

deleting duplicate values

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    deleting duplicate values

    i have a set of around 20000 different names in which there are a many duplicates, i need to delete them all at once, and i need to create a macro for it. I know how to use conditional formatting to highlight all the duplicate cells but how do i delete all of them along with the adjacent cell to its right side?

    i used one technique where it identifies the color of the cell and deletes it but that is only working if i have actually colored the cell but not when its colored bcoz of conditional formatting, so please help as i get more than 20 such files every week and its very difficult to maintain such huge database without using excel.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: deleting duplicate values

    Do you want to delete the unique value and duplicate or only the duplicate value and retain the unique value?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: deleting duplicate values

    Hi,
    Do you know about:
    http://office.microsoft.com/en-us/ex...010073943.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: deleting duplicate values

    i want to delete both the unique and duplicate value.

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: deleting duplicate values

    Do you have a sample file that you can upload?

+ 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