Learn Excel Episode 928: WIIW - Multiple Consolidation

Posted in Companies, Podcasts on January 22, 2009

Another solution to matching data on two worksheets is the Multiple Consolidation Ranges option in the pivot table. Unfortunately, it is much harder to find in Excel 2007. Episode 928 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table