Today Bill looks at Extreme Excel. It seems that Abhijeet took INDIRECT to the extreme – 1200 Formulas, each looking at 5600 Records and the Recalc time is taking too long. In Episode #1824, MrExcel shows us Two ways to build those Formulas without the use of the INDIRECT Function.

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!