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.
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.
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.
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.
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.