Excel BYCOL Function (365)
Description
The Excel BYCOL function applies a LAMBDA function to each column in a given array and returns the result per column as a single array. For example, if the array is 3 columns and 4 rows, it returns an array in 3 columns and 1 row.
Formula syntax
Arguments
|
Returns
The BYCOL function returns one result per column.
Errors
1. An invalid LAMBDA function or an incorrect number of parameters in the formula will return #VALUE error.
2. Not providing LAMBDA function or anything but a single value return from LAMBDA function will return #CALC error.
Version
Excel 365
Usage and Examples
Basic usage
For getting the minimum value of each column in range A1:C4, please use the BYCOL function as this:
=BYCOL(A1:C4,LAMBDA(array,MIN(array)))
Press Enter key, then the minimum values in each column in array A1:C4 have been outputted.
Other Functions:
-
Excel POISSON Function
The Excel POISSON function returns the Poisson distribution which is used to predict the number of events occurring over a specific time.
-
Excel WEIBULL Function
The Excel WEIBULL function returns the Weibull probability density function or Weibull cumulative distribution for a supplied set of parameters.
-
Excel Z.TEST Function
The Excel Z.TEST function (2010) returns the one-tailed P-value of a z-test which is useful for various analyses.
-
Excel F.DIST Function
The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
