Blogs from Wise Owl on Tables, pivot tables in Excel

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.