### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Daily Download 7: Lateraly loaded pile analysis
- Using LINEST for non-linear curve fitting
- Cubic Splines
- LatPile - Analysis of Lateral Loads on Piles
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- The angle between two vectors, Python version

### Recent Comments

dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…

# 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