Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Continuous Beams With Spring Supports by Macaulay’s Method
- Using Excel's shortest functions
- Using LinEst() on data with gaps
- Biaxial bending update
- Section Properties of Defined Shapes - Spreadsheet
- Smart Indenter and Excel 2013
- Drawing in Excel 7 - Creating drawings from coordinates
- Automatic download of csv files
Recent Comments
Tag Archives: Power Query
VBA vs Power Query vs Python
A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits. This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading
Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment