+ Reply to Thread
Results 1 to 5 of 5

Duplication removal in cells!!!

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    60

    Unhappy Duplication removal in cells!!!

    Hi guys,
    I have a excel sheet with Names of few employees and their skills based on the different platforms as in the sheet "Words".
    My requirement is
    1.) the skills in some cells are starting with comma say cell B4.I want to remove it for all the values which is starting with comma.
    2.) In some cells the values are repeated ( there is duplication) example cell B16 i.e ASP.net and Silverlight are repeated twice.I want to remove these duplication also.
    Can anyone please help on this using a VBA program.As there are lot of rows.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Duplication removal in cells!!!

    This does the first part. For the second part, the duplicates are not exact match.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Duplication removal in cells!!!

    Hi Devpp,
    try it
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-27-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Duplication removal in cells!!!

    Thanks nilem!!!
    your code worked awesome...
    Thanks a ton !!!

  5. #5
    Registered User
    Join Date
    08-23-2010
    Location
    india,Chennai
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Duplication removal in cells!!!

    Try this

    Please Login or Register  to view this content.

+ 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