Difference between revisions of "Manuals/calci/INDEX"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <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 | ||
| + | *<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 (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>Ranges</math> can be an array or range of cells. |
| + | *<math>Row</math> and <math>Column</math> should represent row number and column number respectively in the reference range. | ||
| + | *If <math>Row</math> or <math>Column</math> is omitted, 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 == | |
| − | + | Consider the following example in Calci of employee information - | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="1SpaceContent" class="zcontent" align="left"> | <div id="1SpaceContent" class="zcontent" align="left"> | ||
| Line 40: | Line 23: | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | | | + | | class="sshl_f" | '''Name''' |
| − | | class=" | + | | class="sshl_f" | '''Age''' |
| − | | class=" | + | | class="sshl_f" | '''Salary''' |
| − | | | + | | class="sshl_f" | |
| + | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | Row1 | + | | class="sshl_f" | Row1 |
| − | | class="sshl_f " | | + | | class="sshl_f" | John |
| − | | class="sshl_f" | | + | | class="sshl_f" | 32 |
| − | | class="sshl_f" | | + | | class="sshl_f" | 6000 |
| − | | class=" | + | | class="sshl_f" | |
| + | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | Row2 |
| − | | class="sshl_f" | | + | | class="sshl_f" | Sally |
| − | | class="sshl_f" | | + | | class="sshl_f" | 40 |
| − | | class="sshl_f" | | + | | class="sshl_f" | 6600 |
| − | | class=" | + | | class="sshl_f" | |
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | | Row3 | + | | class="sshl_f" | Row3 |
| − | | class="sshl_f" | | + | | class="sshl_f" | David |
| − | | class="sshl_f" | | + | | class="sshl_f" | 28 |
| − | | class="sshl_f" | | + | | class="sshl_f" | 4500 |
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | | Row4 | + | | class="sshl_f" | Row4 |
| − | | class="sshl_f" | | + | | class="sshl_f" | Marie |
| − | | class="sshl_f" | | + | | class="sshl_f" | 28 |
| − | | class=" " | | + | | class="sshl_f" | 5000 |
| − | | class=" " | | + | | class="sshl_f" | |
| + | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | Row5 | + | | class="sshl_f" | Row5 |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | | class=" | + | | class="sshl_f" | |
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class=" | + | | class="sshl_f" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | =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. | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|Se_HcWILzKU|280|center|INDEX}} | |
| − | + | == See Also == | |
| + | *[[Manuals/calci/OFFSET | OFFSET]] | ||
| + | *[[Manuals/calci/ROW | ROW]] | ||
| + | *[[Manuals/calci/COLUMN | COLUMN]] | ||
| − | + | == Reference == | |
| + | *[http://en.wikipedia.org/wiki/Database_index Database Index] | ||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 14:25, 9 August 2018
INDEX (Ranges,Row,Column,RangeIndex)
- where, is the reference to one or more cell ranges or an array
- 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.
is the reference to one or more cell ranges or an array
is the row number in reference
is the column number in reference
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.
Related Videos
See Also
Reference