Recent Comments
Compiled AlgLib Matr… on Compiled AlgLib Matrix Functio… 
guddu on Automatic download of csv… 
dougaj4 on Return of Excel – Evalua… 
phix345 on Return of Excel – Evalua… New sort functions a… on A Sort Function 
smartcarrion on 64 bit Excel and PtrSafe dougaj4 on 3DFrame – 3D Frame analy… 
Mark Firkins on 3DFrame – 3D Frame analy… Lennox Bridge | Newt… on Trinity Bridge and Bridge of t… Trunc Function In Ex… on More Numpy with Excel and… dougaj4 on Using LinEst() on data with… 
Charlene on Using LinEst() on data with… dougaj4 on Jaqui Mcshee 
raduga fenerbahce on Jaqui Mcshee 
John on Installing Adobe Reader non-DC…
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
