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.
Monthly Archives: February 2023
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.
Customised Workbook Toolbars in Excel
You can customize the Quick Access Toolbar and improve your productivity by adding icons that you use frequently. You also add icons that only appear for certain workbooks.
Excel Power Query Errors List
Sometimes Power Queries generate errors. Some errors stop all data being returned and others will return a blank cell for the error in the returned table. You can list the rows that are generating the errors. This can help you identify what is causing the error.
If you think you understand everything that is going on, you are hopelessly confused.
Walter Mondale
Excel VBA to Get to the Top Left of the Screen
Sometimes when you are using Excel VBA you need the screen to always display at the top, left of the sheet. Here is how you do it.
Dreams are the seedlings of realities.
James Allen