Adding Up a Specific Column in an Excel Spill Range
If you have a 2-dimensional spill range in Excel and you need to add up a specific column here is an easy formula to use.
(more…)Excel Copy Across Macro
When you work with dynamic arrays and spill ranges you get used to the formula automatically spilling across to populate a range. When you aren’t using dynamic arrays, it can be frustrating to have to copy formulas across. Here’s a simple macro solution. In the image below I need to copy cell C3 across to the range D3:N3. This is a standard budget layout in Australia where the financial year starts in July. A one-line macro command can copy this…
Select a Spill Range
The Ctrl + A shortcut has been around for a long time and over the years it's functionality has expanded. The latest addition to it's abilities is selecting a spill range. Select any cell in a spill range and press Ctr + A and it will only select the current spill range. This can be useful for formatting as the format doesn't spill.
Pasting from Word to Excel
I was recently updating some Word-based templates, and I remembered how clunky it is to paste from Word to Excel. Here is a short tip to make it easier.
(more…)Excel Formula for Duplicates
I had question in a webinar recently about a formula to list duplicated values. There may be a shorter formula, but I found and shared a solution.
(more…)