My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Distinct Count Formula|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Distinct Count Formula|General Excel Questions & Answers|Excel Forum|My Online Training Hub

office scripts course

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Distinct Count Formula
Avatar
Kasey Crumrine

New Member
Members

Power BI

Power Query

Power Pivot
Level 0
Forum Posts: 2
Member Since:
September 21, 2017
sp_UserOfflineSmall Offline
1
April 29, 2020 - 11:33 pm
sp_Permalink sp_Print

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. 

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 880
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
April 30, 2020 - 5:35 am
sp_Permalink sp_Print

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

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Marcel Bila, Shawn Ward, Nicholas Meyer, Andrew Mansour, Sheryl Gill, Rob Starren, Leigh Thomas
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28551

 

Member Stats:
Guest Posters: 49
Members: 32804
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen