topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • October 23, 2018, 11:52 AM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Is it possible to group names by fuzzy logic?  (Read 381 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,681
    • View Profile
    • Donate to Member
Is it possible to group names by fuzzy logic?
« on: September 26, 2018, 11:07 AM »
Hello!

My data has several client names. It is very often that there are several names of the group of one client.

For example, Batavia Insurance, Batavia Fund, etc probably belong to the Batavia group.

It would mostly work if I match the first word, so how could I write an Excel function to group/count entries that their cell has the same first word?

But it is not 100% safe, eg when you have PT Batavia Company and a prefix kills your algo.

I know it will never be 100% accurate, but do you have any idea how to approach this?

Thanks!

King44

  • Participant
  • Joined in 2018
  • *
  • default avatar
  • Posts: 1
    • View Profile
    • Donate to Member
Re: Is it possible to group names by fuzzy logic?
« Reply #1 on: September 27, 2018, 09:52 AM »
Hello!

My data has several client names. It is very often that there are several names of the group of one client.

For example, Batavia Insurance, Batavia Fund, etc probably belong to the Batavia group.

It would mostly work if I match the first word, so how could I write an Excel function to group/count entries that their cell has the same first word?

But it is not 100% safe, eg when you have PT Batavia Company and a prefix kills your algo.

I know it will never be 100% accurate, but do you have any idea how to approach this?

Thanks!
I also need to know how to approach this?

NetRunner

  • Participant
  • Joined in 2018
  • *
  • default avatar
  • Posts: 11
    • View Profile
    • Donate to Member
Re: Is it possible to group names by fuzzy logic?
« Reply #2 on: September 28, 2018, 07:02 AM »
Download Fuzzy Lookup Add-In for Excel:
https://www.microsof...etails.aspx?id=15011

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 7,226
  • Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Is it possible to group names by fuzzy logic?
« Reply #3 on: September 28, 2018, 10:38 AM »
Download Fuzzy Lookup Add-In for Excel:
https://www.microsof...etails.aspx?id=15011

Nice find! Looks interesting.    :Thmbsup:

I downloaded it to try it out, but I have Win10-64 Pro and MS Office Excel 2016 and noticed that that wasn't covered (not necessarily forwards compatible) in the page The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel, where it says:
(Copied below sans embedded hyperlinks/images, with my emphasis.)
Supported Operating System
Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Vista

Preinstalled Software (Prerequisites): Microsoft Excel 2007, 2010 or 2013
1 GHz processor, 1 core or higher
1 GB of RAM
2 GB of available hard disk space
The following libraries are required and will be installed if necessary:
.NET 4.5
VSTO 4.0

As a long-time Excel ASAP Utilities user, I couldn't seem to get any joy from site:asap-utilities.com/ "fuzzy" either.
Still, I shall try this one out (suck-it-and-see). Stuff from Microsoft Labs is usually pretty tolerant.