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
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Daily Download 5: Frame Analysis
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Tag Archives: Sort Functions
Cleaning Data – Sort functions and shortcuts
Back in 2020 I posted here on New sort functions and sorting to groups, looking at using the sort functions to clean data. Revisiting that post I found that the link to the sample spreadsheet was broken, and that is now … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Excel and pdfs, Shortcuts for cleaner data, Sort Functions
Leave a comment
More Sort Functions
I have recently added three new sorting User Defined Functions (UDFs) to the SortFunc-py spreadsheet, and added a new option to the SortV function. The new file may be downloaded from SortFunc.zip, including full open source code. The first new function … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Dynamic Sort, Excel, Sort Functions, Sort rows, UDF, VBA
2 Comments