BYCOL Function
The Excel BYCOL function applies a LAMBDA function to each column in a given array and returns one result per column as a single array. In the example shown, data is the named range C5:H9.
Note: BYCOL is a beta function available...Read more