COLUMN.AT
Extracts a specific column from a given matrix and returns the specific column as a column vector.
Syntax:
COLUMN.AT(matrix, index)
matrix is the two dimensional range of the matrix you are giving.
index is the zero-based index of the column you want to extract.
Example:
If A1:C3 contains numbers 1 to 9, and index contains 1:
COLUMN.AT(A1:C3, 1)
returns [[2],[5],[8]]
A | B | C | D | ||
|---|---|---|---|---|---|
1 | 1 | 2 | 3 | [[2],[5],[8]] | |
2 | 4 | 5 | 6 | ||
3 | 7 | 8 | 9 |
Application:
Imagine a table showing the quarterly sales data for three different products: Product A, Product B, and Product C.
Sales Table:
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |||
|---|---|---|---|---|---|---|
A | B | C | D | E | ||
1 | Product A | $50,000.00 | $55,000.00 | $60,000.00 | $62,000.00 | |
2 | Product B | $35,000.00 | $38,000.00 | $40,000.00 | $41,000.00 | |
3 | Product C | $20,000.00 | $22,000.00 | $25,000.00 | $27,000.00 |
Let's say we want to extract the sales data for Quarter 3.
- Table Matrix: The entire table of sales data.
- Column Index: The column we want to extract, which is Quarter 3. The column index for Quarter 3 is 2.
If the COLUMN.AT function existed, we would use it like this:
COLUMN.AT(Sales Table, 2)
This would return a column vector containing the sales figures for Quarter 3:
Result:
This vector now represents the total sales for each product during the third quarter, which could be used for further analysis, like calculating the total sales for that quarter or comparing it with other quarters.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof