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?