I wanted to use SimMetrics to find string matches within MS Excel, like finding the closest match in a range of cells and also a closest match VLOOKUP. In the end, I wrote a wrapper around SimMetrics so it could be used in Excel and created a couple of functions (UDFs) in an Excel Add-in to provide these features.
If anyone is interested in using Add-in, it can be found here: http://thefoolonthehill.net/SimMetrics_VBA_Add-In.htm
Note that I am not associated in any way to the SimMetrics team. Thanks go to them for letting me put a link in the forum. Hopefully someone else will find the Add-in useful.
Thanks for this if other people find this useful I can add it into a bigger download
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.