Learn Excel Episode 870: GetPivotData

Posted in Companies, Podcasts on October 20, 2008



You could solve yesterday's podcast using the often-cursed-at, but seldom-understood GETPIVOTDATA function. In Episode 870, how to use GETPIVOTDATA to return the grand total and also using =IF(ISBLANK to clean up stray results below the pivot table.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table, ISBLANK, GetPivotData