Manuals/calci/GETCOLUMN

Revision as of 15:10, 18 December 2017 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''GETCOLUMN (Array,Column)'''</div><br/> *<math>Array</math> is any set of values. *<math>Column</math> is the column number. ==Description== *T...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
GETCOLUMN (Array,Column)


  • 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

  1. GETCOLUMN([[1,2,3],[9,8,7],[10,11,12]],2) = 2 8 11
  2. GETCOLUMN([[13,-12,-90,23,45],[22,-54,-32,-100,65]],3) = -90 -32
  3. GETCOLUMN([[1,4.3,8.9,-56,34,-12,-23],[12,-34,-21,-20,-6.7,9.0]],5) = 34 -6.7

See Also

References