Recent Comments
A Very Short Article… on Is Hinchliffe’s Rule Tru… 
dougaj4 on Using LinEst() on data with… 
Chris on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Chris on Using LinEst() on data with… dougaj4 on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … 
Sunny on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … Sunny on Concrete ULS spreadsheet … Using Numba with Exc… on Two Timers 
masood bhatti on Deflections and Moments in Rec… Kapasitas Lateral Ti… on LatPile – Analysis of La… 
mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness…
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
