xrUCS‖

CTeMG‖BYCOL

zRSxP‖Applies a lambda function to each column of an array. Returns a single-row array of the same number of columns of the source array.

mMG2J‖Enter the formula as an array formula. Hint: enter formula using keys Ctrl + Shift + Enter.

ebLBc‖Syntax

VFGFn‖=BYCOL(Array; Lambda)

cuWto‖Array: the source array.

3MKuL‖Lambda: A function (LAMBDA or other) that will be called on each column of the array.

GAZG2‖Examples

MiUAf‖Example

YyThq‖The following data will be used as example

	A	B	C
1	U37rK‖Maths	EQ45W‖Physics	AEvwX‖Biology
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

BTRGX‖The formula =BYCOL(A2:C13;LAMBDA(class;AVERAGE(class))) return the array

VMf5D‖41.9090909090909

CHKKf‖59.7

rbBYx‖44.7

eRLNJ‖The same results can be obtained using the formula =BYCOL(A2:C13;AGERAGE).

XAFa7‖Technical information

wB7Kb‖This function is available since LibreOfficeDev 27.2.

Gewrf‖This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.BYCOL

BYROW

MAP

5JFLB‖BYCOL wiki page.