Manuals/calci/INDEX - Revision history

Devika at 20:25, 9 August 2018

2018-08-09T20:25:41Z

Devika at 20:25, 9 August 2018

2018-08-09T20:25:14Z

Devika: /* Examples */

2018-04-04T19:00:57Z

Examples

Jayaram at 11:28, 14 March 2017

2017-03-14T11:28:29Z

Swapna at 18:28, 28 April 2015

2015-04-28T18:28:14Z

Swapna at 14:33, 31 December 2013

2013-12-31T14:33:41Z

Swapna at 14:30, 31 December 2013

2013-12-31T14:30:03Z

Swapna at 14:22, 31 December 2013

2013-12-31T14:22:05Z

Swapna at 14:12, 31 December 2013

2013-12-31T14:12:15Z

Swapna at 14:09, 31 December 2013

2013-12-31T14:09:20Z

Show changes

@@ Line 1: / Line 1: @@
 <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
 *<math>Row</math> is the row number in reference

@@ Line 1: / Line 1: @@
 =INDEX(ref, rnum, cnum)=
-*where, <math>ref</math> is the reference to one or more cell ranges or an array
+*where, <math>Ranges</math> is the reference to one or more cell ranges or an array
-*<math>rnum</math> is the row number in reference
+*<math>Row</math> is the row number in reference
-*<math>cnum</math> is the column number in reference
+*<math>Column</math> is the column number in reference
+**INDEX(), function uses an index to choose a value from a reference or array.
 == 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.
-*<math>rnum</math> and <math>cnum</math> should represent row number and column number respectively in the reference range.
+*<math>Row</math> and <math>Column</math> should represent row number and column number respectively in the reference range.
-*If <math>rnum</math> or <math>cnum</math> is omitted, Calci displays #NULL error message.
+*If <math>Row</math> or <math>Column</math> is omitted, Calci displays #NULL error message.
-*If <math>rnum</math> is zero(0), <math>cnum</math> is required. Calci displays entire column in the selected range.
+*If <math>Row</math> is zero(0), <math>Column</math> is required. Calci displays entire column in the selected range.
-*If <math>cnum</math> is zero(0), <math>rnum</math> is required. Calci displays entire row 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>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> and <math>Column</math> do not point to a cell within an array or reference, Calci displays #NULL error message.
 == Examples ==

@@ Line 71: / Line 71: @@
   =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.
+  =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==

← Older revision		Revision as of 11:28, 14 March 2017
Line 84:		Line 84:
	== Reference ==		== Reference ==
	*[http://en.wikipedia.org/wiki/Database_index Database Index]		*[http://en.wikipedia.org/wiki/Database_index Database Index]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 72: / Line 72: @@
   =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.
 == See Also ==

@@ Line 67: / Line 67: @@
   =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(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.
@@ Line 76: / Line 76: @@
 == Reference ==
-*[http://en.wikipedia.org/wiki/Concatenation Concatenation]
+*[http://en.wikipedia.org/wiki/Database_index Database Index]

@@ Line 24: / Line 24: @@
 |- class="even"
 | class=" " |
-| class="sshl_f" | Name
+| class="sshl_f" | '''Name'''
-| class="sshl_f" | Age
+| class="sshl_f" | '''Age'''
-| class="sshl_f" | Salary
+| class="sshl_f" | '''Salary'''
 | class="sshl_f" |
@@ Line 65: / Line 65: @@
 |}
-  =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,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(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(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({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.
 == See Also ==