Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Time in hours and minutes between two dates
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The angle between two vectors, Python version
- Cubic Splines
Recent Comments
Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…
Tag Archives: using Excel function wizard
Getting near matches from a list with Python
To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple. Here is the code for this operation, using pyxll to … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs
Tagged close matches, Excel, Python, PyXLL, UDFs, using Excel function wizard
Leave a comment