The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]
Resize a range of values
The user defined function demonstrated in the animated ggif below, resizes a range you specify to columns or rows you also […]
Prepare data for Pivot Table – How to split concatenated values?
This article demonstrates a macro that allows you to rearrange and distribute concatenated values across multiple rows in order to […]
Normalize data [VBA]
To be able to use a Pivot Table the source data you have must be arranged in way that a […]
Most used functions
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.