Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Beam actions and deflections by Macaulay's Method
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
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