Gercovdbrink
New Member
- Joined
- Apr 24, 2012
- Messages
- 1
I have found some information on the website of MrExcel about Fuzzy Match. I am looking for a function like this.
I have got text in colomn A. I want to have this formula working that it will give me a percentage match to the highest percentuage hit in colomn C. (Any row)
For example,
Cell A1; 3M Spare HV Motor Service
Cell C450; 3Y Spare LV Motor Ser
Cell C5000; 3M HV Spare Moto Service
Which cell within the entire C colomn has the highest hit (%) with Cell A1?
I have found this information; http://www.mrexcel.com/pc07.shtml
But i can't make it work in my case. Can somebody help me??
Thanks in advance!
Kind regards,
Gerco van den Brink
I have got text in colomn A. I want to have this formula working that it will give me a percentage match to the highest percentuage hit in colomn C. (Any row)
For example,
Cell A1; 3M Spare HV Motor Service
Cell C450; 3Y Spare LV Motor Ser
Cell C5000; 3M HV Spare Moto Service
Which cell within the entire C colomn has the highest hit (%) with Cell A1?
I have found this information; http://www.mrexcel.com/pc07.shtml
But i can't make it work in my case. Can somebody help me??
Thanks in advance!
Kind regards,
Gerco van den Brink
