Sample file: How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel
This is the demonstration file to accompany the article, How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel, by Susan Harkins.
From the intro of this Microsoft Excel tutorial:
Most Microsoft Excel functions are autonomous—one result value for each function or formula. For example, you might use SUM() to return the sum of all the values in a single column. If you want to do the same for adjacent columns, you copy the SUM() function or manually enter the function for each column you’re evaluating. Using Excel’s BYCOL() and BYROW() functions, you can enter one function and return an array result set. What’s the advantage? For the most part, using one function instead of many will be more efficient. However, as you’ll see, when combined with other Excel functions, these two functions can do a lot of grunt work.