Calculate The MEDIAN of the last 10 Entries in a column. Bill uses OFFSET with COUNT. Mike uses an Array Formula from his upcoming “Ctrl + Shift + Enter” book to find the last 10 Non-blank Cells. Check out Episode #1735 – and click the following link *to pre-order Mike’s book: *


And, if you would like to get a visual, step-by-step, hands-on approach to learning the finer points of using Array Formulas, Check out Mike’s new DVD:

"Ctrl+Shift+Enter" DVD by Mike 'ExcelisFun' GirvinArray Formulas are a powerful tool in Excel. An Array Formula works with a series of Data Values instead of a single Value. Excel Array Formulas are mysterious, even to people who use Excel 40 hours a week. Although elusive, Array Formulas can be used to solve everyday Excel problems – and Mike “ExcelisFun” Girvin has stepped up to show us how! Click here for more information about Mike’s New DVD,“Ctrl+Shift+Enter”…

Todays’ Podcast is brought to us by. . .

“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! 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series” — Your One Stop for Excel Tips and