Results 1 to 11 of 11

Finding duplication in name list

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    9

    Finding duplication in name list

    Excel 2010 does have a function to remove duplicates. But that only works if the text is exactly the same.

    However, sometimes there some whose names are placed differently (Different placement of Middle and First names).
    For example, "Jason Leong Zhi Kai & Leong Zhi Kai Jason".

    Is there any way to find identify those that are duplicate despite having their middle/first name placed in different orders?

    Any help is greatly appreciated!
    Last edited by bosetan; 04-02-2013 at 08:01 AM.

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