Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- RCInteract and RC Design Functions 7.03
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
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 Excel, Python, Rank function, Sorting, UDF, VBA
1 Comment