With dynamic arrays making array calculations more accessible and easier to use here is a hack for using array syntax in Excel formulas.
Monthly Archives: September 2022
The most powerful people are the ones who never stop learning.
Rejoice Denhere
Quotation Marks in Excel VBA
Sometimes when you are building a text string in VBA you may need to insert quotations marks. That poses a problem because quotation marks are used to surround the text you want to join and using them within the text is problematic. There is a solution.
To understand recursion, one must first understand recursion.
Anonymous
Avoid the #DIV/0! Error in Excel
DIY Function
If you have the subscription version of Excel you can create your own functions. One that you may want to create avoids the #DIV/0! error.
Sparklines and Dates in Excel
A Sparkline chart is a single data series chart (graph) that exists in a cell. Usually, you only need to select one range to create a Sparkline. Sometimes you may need to handle missing dates.
Formatted Table – Change Default Colour
The standard colour for a formatted table is blue.
If you use Ctrl + T to create a table, that’s the colour Excel uses.
You can change the default.
On the Home ribbon tab, click the Format as Table drop-down and right click the colour scheme you want to set as the default.
Select Set As Default from the menu.
Done!
Related Posts
We run the company by questions, not answers.
Eric Schmidt (former chairman and CEO of Google)