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
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