Learn Excel – “Dynamic Range for a Pivot Table” – Podcast #1748

July 11, 2013 at 3:20 pm

Pivot Tables! Bill’s favorite subject.  So the story goes like this:

“Tom’s co-workers created a monster today. They have 15,000 Rows of Formulas that are pulling Data forward from a Query, but filling the extra Rows with “”. So, when Tom tries to create a Pivot Table, it is seeing the “” as Text and causing the Pivot Table to Count instead of Sum.”

Normally, you would use a Ctrl+T Table, but the use of “” won’t allow that to work. So – pretending like this is Excel 2002 and dusting off the =OFFSET Function for Episode #1748, Bill creates a Dynamic Range. Bill says, “…I really thought I would never have to do this again, but Tom’s co-workers forced me into it.”

"Pivot Table Data Crunching Excel 2013" by Bill Jelen

Pivot Table Data Crunching Excel 2013“, by Bill Jelen. Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!

Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

And if you need to know more about Microsoft Excel 2013 in depth…

"Excel 2013 InDepth" - by Bill Jelen

Microsoft 2013 InDepth” – by Bill Jelen has that information. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Entry filed under: 2013, Bill Jelen. Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , .

Learn Excel – “Align Two Tables” – Podcast #1747 Dueling Excel – “Prevent VLOOKUP from Returning Zero” – Podcast #1750

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 735 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: