Changes

|}

|}

  =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 ==

== See Also ==