Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
17
Views
Topic starter
Hi,
Is there a formula or a process I can take in Excel to either remove partial duplicates or get a distinct count of Suppliers where the supplier is listed several times in different ways. For example one cell may have puncutation or is abbreaviated.
Posted : 30/04/2020 9:33 am
Hello,
There are some tools and methods you can use, most of them only looks for exact duplicates. I found a web page here that gives short explanations on how to go about. The difficulties will surely be defining what is a duplicated value when dealing with abbreviations.
Br,
Anders
Posted : 30/04/2020 3:35 pm