Pivot Table

Episode 377 – GetPivotData Function

               

In Excel 2002+, try to create a formula next to your pivot table. When you copy this formula down to other cells, the formula keeps pointing at the original cells! Is this a bug? No, it’s a feature! Well, whatever it is, in Episode 377 I will show you how to stop the functionality so(…)

Episode 358 – Top Five

               

In episode 358, a great new trick from Adam in the UK to solve the problem from Episode 273. I had previously lamented that when you use the Top 10 AutoShow feature of a pivot table, there is no good way to show one line with all of the other customers. Adam’s trick shows how(…)

Learn Excel from MrExcel