Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel - 3, Continuous beam or frame
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- RCInteract and RC Design Functions 7.03
- Linking Excel to C - 2
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