### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Combining arrays
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Numerical integration with on-sheet calculations
- Retrieving unique values from a range or array ...

### Recent Comments

dougaj4 on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… XY Chart problems… on Plotting Charts With Gaps… XY Chart problems… on When is an XY chart not an XY… XY Chart problems… on XY Chart problems –… dougaj4 on RC Design Functions 8_03 alan green on RC Design Functions 8_03

# Category Archives: Arrays

## Excel functions that return references and new functions

The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading

## XY Chart problems – 2

The previous chart post (XY Chart problems – 1) looked at problems plotting charts with very short data ranges. An associated problem is plotting XY charts with data with gaps (see When is an XY chart not an XY chart …? and … Continue reading

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA
Tagged Charts, Excel, UDFs, VBA, XY chart, XY chart displays as line, XY chart with gaps
Leave a comment

## More Python Traps

I recently posted on some Python Traps, focussing on code where changes in the values of sub-routine arguments were not reflected in the calling routines. The reverse can also be a problem: if an array, a, is passed to a … Continue reading

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Numpy, Passing variables, Python, python traps, PyXLL, UDF
Leave a comment

## LinEstGap with non-linear functions

The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data. It … Continue reading

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Exponential curves, Linest, Linest with gaps, Log curves, non-linear curve fitting, Polynomial curves, Power curves, UDF, VBA
1 Comment

## Python Traps

When converting existing VBA code to Python there are a number of obvious changes to the syntax that need to be made for the code to run at all, but there are also a number of not so obvious traps … Continue reading

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, for loop counters |, Numpy, Passing variables, Python, python traps, PyXLL, UDF, VBA
1 Comment