Microsoft Office Tutorials and References
In Depth Information
FIND THE CLOSEST MATCH
and B2, the result may be different, as shown in row 3. Here, A3 and B3 share
the same 11 characters, but 11 characters is only 50% of the 22 characters
found in A3.
Figure 127. h e FuzzyPercent user-dei ned function in this
workbook calculates the percentage of the characters that are in the same
Note that the algorithm is not perfect. Elvis and lives contains exactly
the same characters, but in a completely different order. But is it completely
different? Both cells have the characters l-v-s in the same sequence, so it
appears to be a 3-out-of-5, or 60%, match.
The problem becomes more complex when you have to ﬁ nd the best matches
from two lists. In Figure 128, a two-dimensional table shows how well each
item from the forecast list in column A matches up with the ofﬁ cial customer list
in row 1.
Note that GM Lordstown shares just as many characters in common with
General Motors as it does with Abbott Laboratories. To combat this, Al_B_
Cnu offered alternative algorithms for the FuzzyPercent test. You can try
out =FuzzyPercent2() in the sample workbook to see if is matches up your
Figure 128. h
is table highlights the best match in each row using FuzzyPercent.