EXCEL / VBA BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Tables, pivot tables in Excel
Showing blogs 1-4 (out of 4)
Posted by Andy Brown on 22 December 2020
Soon you will be able to display information from almost any common dataset in your Excel worksheets automatically. For now your access will probably be limited to stocks and geographical data, but many more data types (including your own custom ones) should be available soon.
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!
Posted by Andy Brown on 01 November 2013
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
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.