In many Excel dialogs when you use the arrow keys to move around the formula you actually insert cell references from the active cell in the sheet below.
This is frustrating as you usually only want to move within the formula and you might have to exit out of the dialog and start again.
Excel’s SUBTOTAL function is my function of choice for all my subtotaling requirements. See my earlier post here on its features.
Excel’s automated subtotal feature can do most of the work for you and leave you with a nicely summarised list.
If you need to know how many characters are in a cell then use the LEN function. What if you wanted to know how many characters were in a range?
When building dashboards in Excel you frequently need to have multiple charts that are exactly the same size. Luckily Excel makes this reasonably easy to achieve.