Difference between revisions of "Manuals/calci/INDEX"

Latest revision as of 15:25, 9 August 2018

INDEX (Ranges,Row,Column,RangeIndex)

where, $Ranges$ is the reference to one or more cell ranges or an array
$Row$ is the row number in reference
is the column number in reference
- INDEX(), function uses an index to choose a value from a reference or array.

Description

INDEX (Ranges,Row,Column,RangeIndex)

This function displays the cell that is at the intersection of specified row and column number in an array or reference.
can be an array or range of cells.
and should represent row number and column number respectively in the reference range.
If or is omitted, Calci displays #NULL error message.
If is zero(0), is required. Calci displays entire column in the selected range.
If is zero(0), is required. Calci displays entire row in the selected range.
If and do not point to a cell within an array or reference, Calci displays #NULL error message.

Examples

Consider the following example in Calci of employee information -

	Name	Age	Salary
Row1	John	32	6000
Row2	Sally	40	6600
Row3	David	28	4500
Row4	Marie	28	5000
Row5

=INDEX(A1:C4,3,2) :Calculates intersection in the range A1 TO C4 for third row, second column. Returns David's age 28.
=INDEX(A1:C4,2,1) :Calculates intersection in the range A1 TO C4 for second row, first column. Returns Sally as output.
=INDEX(A2:C3,1,3) :Calculates intersection in the range A2 TO C3 for first row, third column.Returns Sally's salary 6600.
=INDEX(A1:C4,0,2) :Displays the entire Age column in the range A1 to C4. Returns 32,40,28,28 as output.
=INDEX([5,10,15;20,25,30;35,40,45],2,3) : Calculates intersection in an array of numbers for second row, third column. Returns 30 as output.

Reference

Database Index

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=INDEX(ref, rnum, cnum)=
+<div style="font-size:30px">'''INDEX (Ranges,Row,Column,RangeIndex) '''</div><br/>
+*where, <math>Ranges</math> is the reference to one or more cell ranges or an array
-*where, <math>ref</math> is the reference to one or more cell ranges or an array
+*<math>Row</math> is the row number in reference
-*<math>rnum</math> is the row number in reference
+*<math>Column</math> is the column number in reference
-*<math>cnum</math> is the column number in reference
+**INDEX(), function uses an index to choose a value from a reference or array.
-INDEX() function displays the reference of the cell at intersection of particular row and column.
 == Description ==
-INDEX(ref, rnum, cnum)
+INDEX (Ranges,Row,Column,RangeIndex)
 *This function displays the cell that is at the intersection of specified row and column number in an array or reference.
-*<math>ref</math> can be an array or range of cells.
+*<math>Ranges</math> can be an array or range of cells.
-*If <math>rnum</math> is omitted, <math>cnum</math> is required. Calci displays entire column in the selected range.
+*<math>Row</math> and <math>Column</math> should represent row number and column number respectively in the reference range.
-*If <math>cnum</math> is omitted, <math>rnum</math> is required. Calci displays entire row in the selected range.
+*If <math>Row</math> or <math>Column</math> is omitted, Calci displays #NULL error message.
-*If <math>rnum</math> and <math>cnum</math> do not point to a cell within an array or reference, Calci displays #NULL error message.
+*If <math>Row</math> is zero(0), <math>Column</math> is required. Calci displays entire column in the selected range.
+*If <math>Column</math> is zero(0), <math>Row</math> is required. Calci displays entire row in the selected range.
+*If <math>Row</math> and <math>Column</math> do not point to a cell within an array or reference, Calci displays #NULL error message.
 == Examples ==
@@ Line 68: / Line 67: @@
   =INDEX(A1:C4,2,1) :Calculates intersection in the range A1 TO C4 for second row, first column. Returns '''Sally''' as output.
   =INDEX(A2:C3,1,3) :Calculates intersection in the range A2 TO C3 for first row, third column.Returns Sally's salary '''6600'''.
-  =INDEX({5,10,15;20,25,30;35,40,45},2,3) : Calculates intersection in an array of numbers for second row, third column. Returns '''30''' as output.
+  =INDEX(A1:C4,0,2) :Displays the entire Age column in the range A1 to C4. Returns '''32,40,28,28''' as output.
+ =INDEX([5,10,15;20,25,30;35,40,45],2,3) : Calculates intersection in an array of numbers for second row, third column. Returns '''30''' as output.
+==Related Videos==
+{{#ev:youtube|Se_HcWILzKU|280|center|INDEX}}
 == See Also ==
@@ Line 77: / Line 81: @@
 == Reference ==
 *[http://en.wikipedia.org/wiki/Database_index Database Index]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]