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.
(more…)
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.
(more…)
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.
(more…)
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.
(more…)