<div>
Montrof ,<br />
<br />
Can you give more details about what you are trying to do.<br />
<br />
Also an example workbook always help..<br />
<br />
Saurabh...
</div>


Montrof ,

Can you give more details about what you are trying to do.

Also an example workbook always help..

Saurabh...

<div>
I am trying to compare values like such<br />
<br />
Cell A1- Cat compare to Cell B1 Cap so they match at 66% since 2 of the 3 characters match. &nbsp;<br />
<br />
Montrof
</div>


I am trying to compare values like such

Cell A1- Cat compare to Cell B1 Cap so they match at 66% since 2 of the 3 characters match.  

Montrof

<div>
Help me Understand which is your base i.e. A1 or B1 hat i mean by that is let's say<br />
<br />
If A1--&gt;Cat<br />
B2--&gt;Capsule<br />
<br />
How much % whether its 66% if cat is base or 28% if capsule is base...<br />
<br />
Saurabh...
</div>


Help me Understand which is your base i.e. A1 or B1 hat i mean by that is let's say

If A1-->Cat
B2-->Capsule

How much % whether its 66% if cat is base or 28% if capsule is base...

Saurabh...

2015-05-26-17-03-08-Microsoft-Excel---Pe

Percentage-Match.xlsm

<div>
Look at the Levenshtein algorithm:<br />
<a href="http://en.wikipedia.org/wiki/Levenshtein_distance" rel="ugc">http://en.wikipedia.org/wiki/Levenshtein_distance</a><br />
<br />
There are several other algorithms listed at the bottom of that wiki article that might be worth consideration. &nbsp;These algorithms have been around long enough that there are coding examples in most languages, including VBA.
</div>


Look at the Levenshtein algorithm:
http://en.wikipedia.org/wiki/Levenshtein_distance [http://en.wikipedia.org/wiki/Levenshtein_distance]

There are several other algorithms listed at the bottom of that wiki article that might be worth consideration.  These algorithms have been around long enough that there are coding examples in most languages, including VBA.

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
Does anyone have a vba function that can tell you the percentage match of two strings. &nbsp;So that I could compare two cells and and get a percentage that they match. <br />
<br />
Thanks,<br />
Montrof
</div>
</div>


Hi experts,

Does anyone have a vba function that can tell you the percentage match of two strings.  So that I could compare two cells and and get a percentage that they match. 

Thanks,
Montrof

VBA Match String Percentage

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.