Category Archives: Arrays

More on TrimRange and the Drop Function

Posted on 20/11/2025 by dougaj4

A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading →

Posted in Arrays, Excel | Tagged , , , , | Leave a comment

The TrimRange Function

Posted on 05/11/2025 by dougaj4

I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 2 Comments

Mandelbrot, Mojo, Numpy and Numba

Posted on 06/10/2025 by dougaj4

I recently read an article about connecting Python to the new Mojo language: Python Can Now Call Mojo The article had some code examples, including code to plot the Mandelbrot set, comparing plain Python, Python with Numpy, and Mojo, and what … Continue reading →

Posted in Arrays, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | Leave a comment

Numpy where and split, and py_Numpy update

Posted on 30/09/2025 by dougaj4

The py_Numpy spreadsheet and associated code has been updated, with two new functions, links to the Numpy on-line help updated, and updates to sorting and polynomial functions. The updated code and spreadsheet can be downloaded from: Updated Numpy files included … Continue reading →

Posted in Arrays, Excel, Link to dll, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment

Random numbers, palindromes and Numpy update

Posted on 09/06/2025 by dougaj4

This post looks at some of the options for generating random numbers in Excel and Python. The code and example spreadsheets can be downloaded from: Updated Numpy files at: py_SciPy.zipCode added to the Pandigital files at: Pandigitals.zip The py_SciPy download … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment