+ Reply to Thread
Results 1 to 4 of 4

Trying to Remove Duplicate Values of Last Name List

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Trying to Remove Duplicate Values of Last Name List

    Hi everybody! So for a project I need to put together a list of Portuguese-speaking last names. So I have various sources where I copied from, so I have one column in excel where I put all that data. I sorted the data to be in the correct alphabetical order. But when I try to remove the duplicate values in that column is says it removed them but it didn't and when it does it leaves many behind. I have tried the trim function, and even formatting but nothing works. If someone could explain to me what the problem is it would be much appreciated! I attached the non-formatted and non-trimmed list, because it doesn't seem to be making a difference.

    Thank you,
    Tim
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Trying to Remove Duplicate Values of Last Name List

    Hi sonicexcel and welcome to the forum
    First of all you need to clean your data

    User formula below to remove unwanted characters

    in B1 and copy formula down

    =TRIM(SUBSTITUTE(A1,CHAR(160),""))
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to Remove Duplicate Values of Last Name List

    thank you so much!

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Trying to Remove Duplicate Values of Last Name List

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove duplicate values in a dynamic list
    By pedrosky1061012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 12:15 PM
  2. Trying to Remove a Duplicate in List
    By Getalinks in forum Excel General
    Replies: 6
    Last Post: 09-05-2013, 02:27 AM
  3. Remove Duplicate Entries in List
    By nofzinger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2010, 06:43 PM
  4. How do I remove duplicate emails from a list?
    By fastrack1 in forum Excel General
    Replies: 2
    Last Post: 01-21-2010, 10:31 PM
  5. How do I remove duplicate entries from a list?
    By E. Reta in forum Excel General
    Replies: 1
    Last Post: 08-24-2005, 02:05 PM

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