BYCOL Function Explained
The BYCOL function in Microsoft Excel is used to rearrange a range of cells by column. It takes two arguments: the range of cells to rearrange and the number of columns in the rearranged range. The function returns a range of cells rearranged by column, with the first column containing the first cell of the original range, the second column containing the second cell of the original range, and so on.
BYCOL Function Syntax
BYCOL(array, col_num, [ascending])
- array: The range of cells to be sorted.
- col_num: The column number to sort by.
- ascending: (Optional) A logical value that specifies whether to sort in ascending or descending order. If omitted, the default is TRUE (ascending).