BY TOPIC
EXCEL / VBA BLOGS
EXCEL BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Tables, pivot tables in Excel
Showing blogs 1-3 (out of 3)
How to create multiple worksheets based on pivot table report filter values
Posted by Andy Brown on 08 December 2017
Did you know that you can automatically generate multiple versions of a pivot table, with each one configured to filter by a different item? We didn't - this blog is an attempt to apologise for our oversight!
How to get row labels for a pivot table group to repeat
Posted by Andy Brown on 01 November 2013
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
How to Remove Duplicates from a List in Microsoft Excel
Posted by Andrew Gould on 12 October 2011
If you've ever had the tedious job of manually scrolling through a long list of data to remove the duplicate entries in Excel then this blog is for you! Discover how to hide or delete duplicated data in Excel 2003, 2007 and 2010.