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: http://tinyurl.com/mpalnha *
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:
Array 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”
MrExcel.com — Your One Stop for Excel Tips and