Manuals/calci/MATCH - Revision history

Devika at 18:57, 23 August 2018

2018-08-23T18:57:07Z

Devika at 20:35, 2 August 2018

2018-08-02T20:35:57Z

Jayaram at 11:22, 14 March 2017

2017-03-14T11:22:22Z

Swapna at 16:27, 10 May 2015

2015-05-10T16:27:33Z

Swapna at 12:37, 21 January 2014

2014-01-21T12:37:40Z

Swapna at 18:52, 15 January 2014

2014-01-15T18:52:20Z

Swapna at 22:29, 14 January 2014

2014-01-14T22:29:27Z

Swapna at 22:21, 14 January 2014

2014-01-14T22:21:32Z

Swapna at 22:05, 14 January 2014

2014-01-14T22:05:24Z

Show changes

MassBot1: Created page with "
'''MATCH'''
2013-10-25T02:39:38Z

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

New page
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''MATCH'''</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">'''lkup_val'''</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">'''lkup_arr'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,m_type)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where lkup_val'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the value which is use to find the value ,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''lkup_arr '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is a contiguous range of cells containing possible lookup values and </font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''m_type'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the number -1, 0, or 1. </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 relative position of an item in an</font></font></font><font color="#000000"><font face="Arial, sans-serif"><font size="2"> </font></font></font>[javascript:AppendPopup(this,'xldefArray_1') <font color="#000000"><font face="Arial, sans-serif"><font size="2">array </font></font></font>]<font color="#484848"><font face="Arial, sans-serif"><font size="2">that matches a specified value in a specified order. </font></font></font></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

MATCH

</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 in Column1Row1:Column1Row4</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Green 45</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Red 39</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Blue 47</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Yellow 26</font></font></font>

<br /><br />

<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=MATCH(40,C1R1:C1R4,1) is 4</font></font></font>

<br />

</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="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
|
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" sshl_f " | Green
| class="sshl_f" | 45
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class="sshl_f " | Red
| class="sshl_f" | 39
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class="sshl_f" | Blue
| class="sshl_f" | 47
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " | Yellow
| class="sshl_f" | 26
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class="sshl_f" | 4
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class="SelectTd " |
| class=" " |
| class=" SelectTD SelectTD" |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|}

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

@@ Line 5: / Line 5: @@
 *'''Array''' is the array of values or reference to the cells containing values
 *'''Type''' specifies the method for matching the value with values in array. It can be -1, 0 or 1.
+**MATCH(), looks up values in a reference or array.
 == Description ==

@@ Line 1: / Line 1: @@
-=MATCH(lkup_val, lkup_arr, m_type)=
+<div style="font-size:30px">'''MATCH (Value,Array,Type)'''</div><br/>
 where,
-*'''lkup_val''' is the value to be matched from the array
+*'''Value''' is the value to be matched from the array
-*'''lkup_arr''' is the array of values or reference to the cells containing values
+*'''Array''' is the array of values or reference to the cells containing values
-*'''m_type''' specifies the method for matching the value with values in array. It can be -1, 0 or 1.
+*'''Type''' specifies the method for matching the value with values in array. It can be -1, 0 or 1.
-MATCH() displays the relative position of a value in an array that matches a specified value in a specified order.
+MATCH(), looks up values in a reference or array.
 == Description ==
-MATCH(lkup_val, lkup_arr, m_type)
+MATCH (Value,Array,Type)
 e.g.
 MATCH("A",["A","B","C"],1) returns relative position of 'A' as '''1'''.
@@ Line 18: / Line 17: @@
 *MATCH() displays the relative position of the matched value in an array.
-*'''lkup_val''' can be a number, text or logical value, or reference to cells containing number, text or logical value.
+*'''Value''' can be a number, text or logical value, or reference to cells containing number, text or logical value.
-*'''lkup_arr''' can be set of values or a reference to cells containing values.
+*'''Array''' can be set of values or a reference to cells containing values.
-*If '''lkup_val''' and '''lkup_arr''' are text values, they should be entered in quotes (e.g. "JOHN").
+*If '''Value''' and '''Array''' are text values, they should be entered in quotes (e.g. "JOHN").
-*The method to find a match can be specified with argument '''m_type'''. If omitted, Calci assumes it to be '1'.
+*The method to find a match can be specified with argument '''Type'''. If omitted, Calci assumes it to be '1'.
-*The following table shows how '''m_type''' works with respect to the order of values in Array-
+*The following table shows how '''Type''' works with respect to the order of values in Array-
 {| class="wikitable"
 |-
-! m_type !! Order of values in Array !!Description
+! Type !! Order of values in Array !!Description
 |-
-| 1 or omitted || Ascending Order || Finds the largest value &lt;= '''lkup_val'''.
+| 1 or omitted || Ascending Order || Finds the largest value &lt;= '''Value'''.
 |-
-| 0 || Any order || Finds the first value exactly equal to '''lkup_val'''.
+| 0 || Any order || Finds the first value exactly equal to '''Value'''.
 |-
-| -1 || Descending order || Finds the smallest value &gt;= '''lkup_val'''.
+| -1 || Descending order || Finds the smallest value &gt;= '''Value'''.
 |}
 *The uppercase and lowercase characters are not distinguished in an array of text values.

← Older revision		Revision as of 11:22, 14 March 2017
Line 83:		Line 83:
	*[http://en.wikipedia.org/wiki/String_(computer_science) String]		*[http://en.wikipedia.org/wiki/String_(computer_science) String]
	*[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]		*[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 63: / Line 63: @@
 |}
-  =MATCH(46,A1:A4,1) : Matches value '46' with that in an array with reference cells A1 to A4. Returns the relative position '''2'''.
+  =MATCH(46,A1:A4,1) : Matches value '46' with that in an array with reference cells A1 to A4. <br />Returns the relative position '''2'''.
-  =MATCH(39,A1:A4,1) : As no exact match, Calci finds largest number in array that is less than '39'. Returns the relative position '''1''' for value '34'.
+  =MATCH(39,A1:A4,1) : As no exact match, Calci finds largest number in array that is less than '39'. <br />Returns the relative position '''1''' for value '34'.
-  =MATCH("MARY",B1:B3,0) : Matches string 'MARY' with that in an array with reference cells B1 to B3. Returns the relative position '''3'''.
+  =MATCH("MARY",B1:B3,0) : Matches string 'MARY' with that in an array with reference cells B1 to B3. <br />Returns the relative position '''3'''.
-  =MATCH(45,C1:C4,-1) : Matches value '45' with that in an array with reference cells C1 to C4. Returns the relative position '''1'''.
+  =MATCH(45,C1:C4,-1) : Matches value '45' with that in an array with reference cells C1 to C4. <br />Returns the relative position '''1'''.
-  =MATCH(2,C1:C4,-1) : As no exact match, Calci finds smallest number in array that is greater than '2'. Returns the relative position '''3''' for value '3'.
+  =MATCH(2,C1:C4,-1) : As no exact match, Calci finds smallest number in array that is greater than '2'. <br />Returns the relative position '''3''' for value '3'.
 == See Also ==

@@ Line 13: / Line 13: @@
 e.g.
-MATCH("A",{"A","B","C"},1) returns relative position of 'A' as '''1'''.
+MATCH("A",["A","B","C"],1) returns relative position of 'A' as '''1'''.
-MATCH(44,{40,42,44},1) returns relative position of '44' as '''3'''.
+MATCH(44,[40,42,44],1) returns relative position of '44' as '''3'''.
 *MATCH() displays the relative position of the matched value in an array.