Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

MS Excel Add-in incorporating SimMetrics

SteveT
2006-09-20
2013-04-26
  • SteveT
    SteveT
    2006-09-20

    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.

    Steve

     
    • ReverendSam
      ReverendSam
      2006-10-12

      Thanks for this if other people find this useful I can add it into a bigger download