• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    using MATCH( match_type with text?

    Thanks for the response, SirJB7. That certainly helps my understanding of MATCH( , but I still don't understand of the third parameter works with non-numerical values. testing a simple list with the third parameter :1 SEEMS to return the last instance of a duplicated text element in an...
  2. D

    using MATCH( match_type with text?

    if I am not mistaken, using MATCH( on an array of unsorted text cells will only return the ordinal position of the FIRST match. is there some way to have it look for the position of the LAST match? EX: a list as follows eggs eggs lemon lemon lemon eggs and have MATCH("lemon" return 5...
  3. D

    using MATCH( match_type with text?

    Hi All, I haven't been able to find any definitive information on how the match_type argument works with text strings instead of values. it seems that if you use the "greater than" match type it will find the largest value, for example: to match "apples" in an array of a1:a10 where each...
Back
Top