BYROW

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

ປ້ອນສູດເປັນ ສູດອາເຣ (array formula). ຄຳແນະນຳ: ປ້ອນສູດໂດຍໃຊ້ປຸ່ມ Ctrl + Shift + Enter.

ໄວຍາກອນ

=BYROW(Array; Lambda)

Array: the source array.

Lambda: A function (LAMBDA or other) that will be called on each row of the array.

ຕົວຢ່າງ

ຂໍ້ມູນຕໍ່ໄປນີ້ຈະຖືກໃຊ້ເປັນຕົວຢ່າງ

	A	B	C
1	ຄະນິດສາດ	ຟີຊິກ	ຊີວະສາດ
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

The formula =BYROW(A2:C13;LAMBDA(student;MAX(student))) return the array

67
68
65
64
43
84
80
49
57
60
57
26

The same results can be obtained using the formula =BYROW(A2:C13;MAX).

ຂໍ້ມູນທາງເຕັກນິກ

This function is available since LibreOfficeDev 27.2.

ຟັງຊັນນີ້ ບໍ່ແມ່ນ ສ່ວນໜຶ່ງຂອງມາດຕະຖານ Open Document Format for Office Applications (OpenDocument) ເວີຊັນ 1.3 ພາກທີ 4: ຮູບແບບສູດທີ່ຄິດໄລ່ຄືນໃໝ່ (OpenFormula). ຊື່ພື້ນທີ່ (name space) ແມ່ນ

COM.MICROSOFT.BYROW

BYCOL

MAP

BYROW wiki page.