Excel Forum
Similar Content
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Simple Excel Function to Combine Text with a Separator
Tutorial: Excel function that makes combining text very easy. This function is simpler and better th...
Excel Function to Remove All Text OR All Numbers from a Cell
Tutorial: How to create and use a function that removes all text or all numbers from a cell, whichev...

Highline Excel Class 39: Forcing Functions To Become Arrays

If an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead of a single value. See these amazing tricks:
1)Count Unique values with SUMPRODUCT & COUNTIF functions array formula
2)Lookup Adding with SUMPRODUCT &SUMIF functions array formula
3)MEDIAN IF functions in array formula (calculating Median with conditions (criteria))
4)MAX IF functions in array formula (calculating maximum value with conditions (criteria))
5)MIN IF functions in array formula (calculating minimum value with conditions (criteria))
6)Adding (summing sum) top three values using SUM & LARGE functions with an array in array sytax
7)Conditional (criteria) adding & counting for dates with the TEXT & SUMPRODUCT functions
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.