Forcing a Function to Spill in Excel

Dynamic arrays can spill. The means a single formula populates a range. Most Excel functions can refer to and use a spill range. This causes the formulas to spill to match the spill range. There are some functions that don’t work with spill ranges. Here is a technique that forces a function to work with a spill range.

Regenesis (2022)

A must read for everyone.

The food system is broken. Farming is broken. The soil, the sea and the climate are all at breaking point.

There are technologies that may get us out of this mess but we need a major shift in our thinking about food and where it comes from.

The new technologies (they aren’t all that new) can help us make the change and not destroy the environment.