Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Taming Symbols in Excel
- Frame Analysis with Excel
- Beam actions and deflections by Macaulay's Method
Recent Comments
Tag Archives: GroupSort Function
New sort functions and sorting to groups
I first posted a user defined function (UDF) to sort spreadsheet or VBA data back in 2009. Finally Microsoft have caught up, and Excel 365 subscribers now have two built in sort functions available: =SORT(array,[sort_index],[sort_order],[by_col]) =SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…) … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, GroupSort Function, Sort Function, Sortby Function, UDF, VBA
Leave a comment