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
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Section Properties with MeshPY, including torsion and warping
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Finding Prime Numbers with Excel, and using Array Formulas
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