Manuals/calci/ROWS - Revision history

Devika at 21:36, 9 August 2018

2018-08-09T21:36:34Z

Devika at 21:35, 9 August 2018

2018-08-09T21:35:22Z

Devika: /* Examples */

2018-04-05T18:26:58Z

Examples

Jayaram at 11:29, 14 March 2017

2017-03-14T11:29:43Z

Swapna at 20:13, 18 April 2015

2015-04-18T20:13:28Z

Swapna at 23:13, 12 December 2013

2013-12-12T23:13:06Z

Swapna at 22:50, 12 December 2013

2013-12-12T22:50:50Z

Swapna: Replaced content with "== ROWS(array) == *where $array$ is an array or reference ROWS() displays the number of rows in an array or reference. == Description == ROWS(array) For Ex..."

2013-12-12T22:47:12Z

Replaced content with "== ROWS(array) == *where <math>array</math> is an array or reference ROWS() displays the number of rows in an array or reference. == Description == ROWS(array) For Ex..."

MassBot1: Created page with "
'''ROWS'''
2013-10-25T02:43:53Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ROWS'''</font></font></font><font color="#484848..."

New page
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ROWS'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is an array,</font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It gives the number of rows in a reference or </font></font></font>[javascript:AppendPopup(this,'xldefArray_1') <font color="#000000"><font face="Arial, sans-serif"><font size="2">array</font></font></font>][javascript:AppendPopup(this,'xldefArray_1') <font color="#484848"><font face="Arial, sans-serif"><font size="2">.</font></font></font>]</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

ROWS

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROWS(C1R1:C3R5) is 5</nowiki></font></font></font>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="4SpaceContent" class="zcontent" align="left">

{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f " | 2
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 5
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" sshl_f " |
| class=" " |
| class=" SelectTD SelectTD" |
<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| class=" " |
|- class="even"
| Row4
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class=" " |
| class=" " | 10027
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" sshl_f sshl_f " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

← Older revision		Revision as of 21:36, 9 August 2018
Line 1:		Line 1:
−	~~== ROWS(arr) ==~~
	<div style="font-size:30px">'''ROWS (Array) '''</div><br/>		<div style="font-size:30px">'''ROWS (Array) '''</div><br/>
	*where <math>Array</math> is an array or reference		*where <math>Array</math> is an array or reference

@@ Line 1: / Line 1: @@
 == ROWS(arr) ==
+<div style="font-size:30px">'''ROWS (Array) '''</div><br/>
-*where <math>arr</math> is an array or reference
+*where <math>Array</math> is an array or reference
+**ROWS() displays the number of rows in an array or reference.
 == Description ==
-ROWS(arr)
+ROWS()
+*For Example,ROWS(B4) ''returns 1''.
-For Example,
+*<math>Array</math> can be a cell, range of cells or an array.

@@ Line 61: / Line 61: @@
   =ROWS(D4)   : Calculates the row number of cell D4. ''Returns 4'' as a result.
   =ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. ''Returns 4'' as a result.
-  =ROWS({3,4;6,7;8,9}): Calculates the number of rows from the given array. ''Returns 3'' as a result.
+  =ROWS([3,4;6,7;8,9]): Calculates the number of rows from the given array. ''Returns 3'' as a result.
 ==Related Videos==

← Older revision		Revision as of 11:29, 14 March 2017
Line 74:		Line 74:

	*[http://en.wikipedia.org/wiki/Row_(database) Row]		*[http://en.wikipedia.org/wiki/Row_(database) Row]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 62: / Line 62: @@
   =ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. ''Returns 4'' as a result.
   =ROWS({3,4;6,7;8,9}): Calculates the number of rows from the given array. ''Returns 3'' as a result.
 == See Also ==

← Older revision		Revision as of 22:50, 12 December 2013
Line 17:		Line 17:

	== Examples ==		== Examples ==
		+
		+	<div id="4SpaceContent" class="zcontent" align="left">
		+
		+	{\| id="TABLE2" class="SpreadSheet blue"
		+	\|- class="even"
		+	\| class=" " \|
		+	\| ColumnA
		+	\| ColumnB
		+	\| ColumnC
		+	\| ColumnD
		+	\|- class="odd"
		+	\| class=" " \| Row1
		+	\| class="sshl_f " \| 2
		+	\| class=" " \|
		+	\| class=" " \|3
		+	\| class=" " \|
		+	\|- class="even"
		+	\| class=" " \| Row2
		+	\| class="sshl_f" \| 5
		+	\| class=" " \|
		+	\| class=" " \|7
		+	\| class=" " \|
		+	\|- class="odd"
		+	\| class=" " \| Row3
		+	\| class="sshl_f" \|
		+	\| class=" " \|
		+	\| class=" " \|9
		+	\| class=" " \|
		+	\|- class="even"
		+	\| class=" " \| Row4
		+	\| class=" " \|
		+	\| class=" " \|
		+	\| class=" " \|11
		+	\| class=" " \|
		+	\|- class="odd"
		+	\| class=" " \| Row5
		+	\| class=" " \|
		+	\| class=" " \|
		+	\| class=" " \|
		+	\| class=" " \|
		+	\|}
		+
		+	=ROWS(D4) : Calculates the row number of cell D4. ''Returns 4'' as a result.
		+	=ROWS(A2:C5): Calculates the row number in the range A2 to C5. ''Returns 4'' as a result.
		+
		+	== See Also ==
		+
		+	*[[Manuals/calci/ROW\| ROW]]
		+
		+	==References==
		+
		+	*[http://en.wikipedia.org/wiki/Row_(database) Row]

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ROWS'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+== ROWS(array) ==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is an array,</font></font></font>
+*where <math>array</math> is an array or reference
-</div>
+ROWS() displays the number of rows in an array or reference.
-ROWS
+== Description ==
-</div></div>
+ROWS(array)
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font>
+For Example,
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ROWS(C1R1:C3R5) is 5</nowiki></font></font></font>
+ROWS(B4) ''returns 1''.
-</div>
+*<math>array</math> can be a cell, range of cells or an array.
-<div align="left">[[Image:calci1.gif]]</div></div>
+== Examples ==