Today’s question for Duel 158: “You have to rent rail tank car #123 for a 3 month period. The daily rate changes twice ; once in
May, and once in June. Given the start date, end date, and the rate changes, how can you calculated the total rental charge or average per day?” In response to the question, Bill shows how he has been reading MIke’s Ctrl+Shift+Enter book and creates an Array Formula. Mike makes the Formula better.
Also, Check Out Mike’s appearance on ExcelTV by Clicking Here.
Although elusive, Array Formulas can be used to solve everyday Excel problems. If you need to figure out how many times your birthday fell on a Friday, an Array Formula can solve that. If you need to return a Unique List of Sales Reps from a Database, an Array Formula can solve that. Now, at your own pace, you can learn the methods, the tricks, the dos and the don’ts that will allow you to “Command The Power of the ‘Array Formula’ in Microsoft Excel“! “Ctrl+Shift+Enter: Mastering Excel Array Formulas” by Mike ‘ExcelIsFun’ Girvin tells all!
…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!