Learn Excel Episode 869: Final Pivot Row?

Posted in Companies, Podcasts on October 17, 2008



Richard is building a formula outside of the pivot table that needs to divide by the grand total of the pivot table. In Episode 869, I show two solutions, one of which is an incredibly geeky use of the other type of VLOOKUP.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas