GETCOLUMN (Array,Column)
where
- is any set of values.
- is the column number.
Description
- This function gives the particular column values from the given set of values.
- In , is the set of values, is the column number in the given array.
- So this function displays the specified column values from the given set of values.
- If we omitted the column number then this function will shows the result as Null for all number of columns.
Examples
- GETCOLUMN([[1,2,3],[9,8,7],[10,11,12]],2) = 2 8 11
- GETCOLUMN([[13,-12,-90,23,45],[22,-54,-32,-100,65]],3) = -90 -32
- GETCOLUMN([[1,4.3,8.9,-56,34,-12,-23],[12,-34,-21,-20,-6.7,9.0]],5) = 34 -6.7