Tag Archives: Table

Calculate The Absolute Sum in Excel

A colleague of mine asked me today how to go about using MS Excel formulas to calculate the sum of absolute values from a given dataset. This question crops up quite often on the forums so I thought I’d put together a quick blog … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , | 2 Comments

Clearing Excel tables

The VBA macro recorder is a really wonderful tool, especially when you want to get an insight into an unfamiliar part of the Excel object model. However, it’s notorious for producing inefficient code – and clearing a table is a … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | 32 Comments