Ctrl + Shift + Enter: Excel Array Formulas 22: Excel 2010 Array Function: MODE.MULT

Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video covers the mode calculation which finds the number that occurs most frequently and specifically it covers the functions MODE.SNGL (find one mode) and the MODE.MULT which returns multiple modes when there are multiple modes: 1. (00:23 min) MODE (2007 or earlier) or MODE.SNGL (2010 or later) finds the number that occurs most frequently. 2. (00:23 min) When there are multiple modes, MODE or MODE.SNGL report only the first one. 3. (01:55 min) When there is more than one mode, MODE.MULT returns an array of modes. 4. (02:10 min) MODE.MULT: quick and dirty method. 5. (03:38 min) MODE.MULT: formula to show blanks instead of #N/A. 6. (02:59 and 07:10 min) Formula to show modes horizontally. THIS VIDEO SERIES AT YOUTUBE IS THE SAME AS THE DVD FROM EXCELISFUN. THESE VIDEOS ARE BEING GIVEN AWAY FOR FREE AT YOUTUBE. SUPPORT THE CAUSE BY GOING TO AMAZON AND BUYING THE BOOK. EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! Buy Ctrl + Shift + Enter: Mastering Excel Array Formulas DVD at A: http://www.amazon.com/Ctrl-shift-enter-Mastering-Formulas/dp/1615470085 Ctrl + Shift + Enter: Mastering Excel Array Formulas Book: http://www.amazon.com/Ctrl-Shift-Enter-Efficient-Calculating/dp/1615470077 Ctrl+Shift+Enter: A Book About Building Efficient Formulas, Advanced Formulas, and Array Formulas for Data Analysis and Calculating Problems Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots. Full playlist of videos at YouTube: http://www.youtube.com/playlist?list=PLrRPvpgDmw0kjL4875H36yNhWBb0f-nci