ROW.AT

Extracts a specific row from a given matrix and returns the specific row as an array or a two-dimensional array.

Syntax:

ROW.AT(matrix, index)

matrix is the two dimensional range of the matrix you are giving.

index is the zero-based index of the row you want to extract.

Example:

If A1:C3 contains numbers 1 to 9, and index contains 0:

ROW.AT(A1:C3, 0)

returns [1, 2, 3]

	A	B	C	D
1	1	2	3	[1,2,3]
2	4	5	6
3	7	8	9

Application:

Let's imagine a spreadsheet application used to track sales data for a small bookstore. The data is organized in a table named "Quarterly Sales," which represents a matrix of information.

The table "Quarterly Sales" looks like this:

	Month	Hardcover	Paperback	E-book
	A	B	C	D
1	January	150	250	100
2	February	180	280	120
3	March	160	260	110

The ROW.AT function can be used to extract a specific row of data from this table.

Example:

To get the sales data for February, we can use the following function:

ROW.AT(Quarterly Sales, 1)

Quarterly Sales is the matrix (the table).
1 is the row index, as "February" is the second row in the table (excluding the header).

Result:

The function would return the following array:

[February, 180, 280, 120]

This array represents the entire row for the month of February, including the month name and the sales figures for each book type. This extracted data could then be used for further calculations, such as summing the total sales for February or displaying a specific line graph for that month.

Result:

["February",180,280,120]