Recent Comments
Author Archives: dougaj4
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
Lennox Bridge
Last December I joined Bill Harvey on a visit to Lennox Bridge west of Sydney. Bill has now documented the visit in his Bridge of the Month site, including history, comments on the structural form, and a dynamic 3D model … Continue reading
Posted in Arch structures, Historic Bridges, Newton
Tagged 3D Model, Bill Harvey, Bridge of the Month, Lennox Bridge, stone arch bridge
Leave a comment
The Concrete Institute of Australia – Golden Jubilee
The Concrete Institute of Australia will celebrate 50 years in 2020. The Institute was originally formed when members of the Australia Prestressed Concrete Group proposed a change in 1968 where it was resolved to adopt the name Concrete Institute of … Continue reading
The String Family
According to their web site, The String family are: A family of classically trained string players who launched their musical career by hitting the road full time from 2016 through 2018, bringing music to people around Australia. Featuring 2 cellos, … Continue reading
Getting near matches from a list with Python
To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple. Here is the code for this operation, using pyxll to … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs
Tagged close matches, Excel, Python, PyXLL, UDFs, using Excel function wizard
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 