Tag Archives: Rank function

Dynamic sorting with Excel, VBA, and Python

A spreadsheet with User Defined Functions (UDFs) to dynamically sort a range of data has previously been presented here and here. I have now modified the Python version of the UDF for improved functionality, added a second Python function, and … Continue reading

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , | 1 Comment