Difference between revisions of "Manuals/calci/GETCOLUMN"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
# GETCOLUMN([[13,-12,-90,23,45],[22,-54,-32,-100,65]],3) = -90 -32 | # 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 | # GETCOLUMN([[1,4.3,8.9,-56,34,-12,-23],[12,-34,-21,-20,-6.7,9.0]],5) = 34 -6.7 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=V3LNbEesLtU|280|center|Column}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:14, 18 March 2019
GETCOLUMN (Array,Column)
where
- is any set of values.
- is the column number.
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