Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Contour plots with Excel and Matplotlib
- Filling Blanks with Go To-Special (and local help rant)
- 3DFrame - 3D Frame analysis for Excel
- Writing Arrays to the worksheet - VBA function
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