# BYCOL

The BYCOL function in Google Sheets operates on an array or range and returns a new row array, created by grouping each column to a single value.

## Usage

Use the `BYCOL` formula with the syntax shown below, it has 2 required parameters:

Parameters:
1. array_or_range (required):
An array or range to be grouped by columns.
2. LAMBDA (required):
A LAMBDA that's applied to each column in the given array or range to obtain its grouped value.

## Examples

Here are a few example use cases that explain how to use the `BYCOL` formula in Google Sheets.

### Calculate the average of each column

The BYCOL function can be used to calculate the average of each column in an array or range. For example, if you have an array of sales data, you could use the BYCOL function to calculate the average sales for each month.

### Find the maximum and minimum value in each column

The BYCOL function can also be used to find the maximum and minimum value in each column in an array or range. For example, if you have an array of exam scores, you could use the BYCOL function to find the highest and lowest score for each subject.

### Count the number of unique values in each column

The BYCOL function can also be used to count the number of unique values in each column in an array or range. For example, if you have an array of customer names, you could use the BYCOL function to count the number of unique customers.

## Common Mistakes

`BYCOL` not working? Here are some common mistakes people make when using the `BYCOL` Google Sheets Formula:

### Forgetting to specify the LAMBDA function

The BYCOL function requires you to specify a LAMBDA function. If you forget to do this, the function will not work.

### Using the wrong type of data in the LAMBDA function

The LAMBDA function must return a single value. If you try to use a function that returns multiple values, the BYCOL function will not work.

### Not using the correct syntax for the LAMBDA function

The LAMBDA function must be in the correct syntax. If you use the wrong syntax, the BYCOL function will not work.

The following functions are similar to `BYCOL` or are often used with it in a formula:

• `ARRAYFORMULA`

The `ARRAYFORMULA` formula in Google Sheets allows for the application of a formula to an entire column or range of data, without needing to manually copy the formula to each cell. It is most commonly used to simplify and automate complex calculations across large data sets.

• `SUM`

The `SUM` function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.

• `AVERAGE`

The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

• `MAX`

The `MAX` function returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset.

• `MIN`

The `MIN` formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.

You can learn more about the `BYCOL` Google Sheets function on Google Support.