With dynamic arrays making array calculations more accessible and easier to use here is a hack for using array syntax in Excel formulas.
The most powerful people are the ones who never stop learning.
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.
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.
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.
We run the company by questions, not answers.
Eric Schmidt (former chairman and CEO of Google)