Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Latex Maths Text in 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