Forum

Notifications
Clear all

Distinct Count Formula

2 Posts
2 Users
0 Reactions
90 Views
(@kcrumrine)
Posts: 2
New Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

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