Hi,
I have 16 k rows of companies names. The list contains information from different data systems. That's why, we may have the same supplier with slightly different names.
My job is to "group" (normalize) this suppliers.
The issue is that I have all of them under one column. Therefore, I can't use the fuzzy look-up add-in.
For example:
Apple
ADIDAS
DELL
Nike Inc.
Nike
Nike LLC
Xiaomi
Please advise.
Regards,
Nangys
Did you try filtering the column with "starts with" or "contains"?
E.g. when you set a filter on the column with "Starts with" "nike" and make it case-insensitive then you would get the rows with "Nike Inc.", "Nike", "Nike LLC" etc.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks