If you using Excel versions prior to 2013 then you may want to look away now...only kidding!!!! But this tip really does only apply to Excel 2013 onwards, that is the ability to count unique items in...
Category: Pivot Tables
Formula Friday – Create A Dynamic Pivot Table Data Source Using OFFSET and COUNTA Functions
Happy Friday Excellers..... Pivot Tables are great for taking hundreds or even thousands of rows of data and be able to summarise and analyse your data set with a few clicks of your mouse, if...
Excel Pivot Table Tip – Show Only The Top 10 Items In A Pivot Table
This tip is really useful if you have a Pivot Table with a large number of Row Items such a product ID's and you only want to show your top selling products. You may have hundreds or even thousands...
Excel VBA Tip -How To Reset All Pivot Table Slicers At The Click Of A Button
I have recently been working on a spreadsheet solution based very much on Pivot Tables and a good deal of Slicers to enable an easy of drilll down into the data. If you have been using any...
If you have a calculated field in your Excel Pivot Table then you may well come across the dreaded #DIV/0! error, which just means that you are attemping to divide a number by zero. To avoid the...
Excel Tip- How To Make cell value formatting stick in a Pivot Table
I have seen this a lot with Pivot tables, the frustration of Excel users when they format their data in a Pivot Table, but they hit refresh or they remove and add back data into the calculations area...