Sometimes a Pivot Table is an intermediate step on the way to something bigger. ModelOff finalist Vlad Smirnov is creating a reserve booking for risky loans at a bank. His SumProduct Formula counts on every risk class being present in every month. But that formula fails when a month doesn’t have loans that fall into all four risk classes. Today Episode #1839 shows us how to tweak the Pivot Table to force all of the risk classes to appear every month, even if there is no data.

LE10_180WP

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

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

ModelOff

ModelOff is a worldwide championship for financial modelling in Excel. 16 finalists were flown to NYC in December 2013 to compete head-to-head. I was there as a judge and took the opportunity to record some Live Podcasts  -Bill 'MrExcel' Jelen