Back

Questions
About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

BBBOnLine Reliability Seal

Member of the National Speakers Association



 

Excel Video Lessons

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video! Sponsored by:

Check out this book for more tips similar to this lesson!
(Click the book for details)

Episode # 358 - Top Five
Prev Next

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 to use the Group feature to solve the problem. Episode 358 shows you how.

Your first click will activate the control, then click the play icon to play the video (requires Flash):

If you like this video, there are hundreds of 2-5 minute videos available here: Tags/Keywords for this video: Pivot Table

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.