Jump to content

Is there any tool or software or excel trick to fix the partial duplicate in text


rraz123
 Share


Recommended Posts

rraz123

Hi There!

I have a list of vendor names in a column and I will like to delete duplicates. I need a way for Excel to identify partial duplicates for example:
ABC Company
ABC Company Inc
ABC Company.
ABC
ABC Company Corp.

I need Excel to tell me that these are potentially the same vendor.

Since I only have one column and we are talking about one data set I cant use Fuzzy Lookup. Please let me know if you have a solution for this!

THANK YOU :)

Edited by rraz123
Link to comment
Share on other sites


  • rraz123 changed the title to Is there any tool or software or excel trick to fix the partial duplicate in text

do they all start with ABC (or any one particular word) ??

 

I will not recommend deleting them straightaway but you can identify them as below and then decide which one to delete.

 

1. Select the full column which contains vendor names

2.  Home >> Styles >> Conditional Formatting >> Highlight cell rules >> Text that contains

3. Select The Header Row

4. Home >> Editing >> Sort and Filter >> Filter >> Filter with text that contains

5. You will have a filtered list

6. select rows to delete

DONE

 

 

Edited by kyber
Link to comment
Share on other sites


rraz123

@kyber Thank you for the solution, I think it is not solution for huge data, I have 50000 vendors lists in one column. 

Link to comment
Share on other sites


1 hour ago, rraz123 said:

50000 vendors

 

How may unique names?

 

Regex also can be used with VBA for automating the task on hand but you need to know the exact list of unique names.

 

HTH

Edited by kyber
Link to comment
Share on other sites


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share


  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...