Results 1 to 10 of 10

Thread: Find... >= tDate

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Do not consider my suggestions as solutions but as suggestions for a method to attain a certain goal.
    You are free to adapt the suggestions to your wishes/requirements.

    you could simply use this formula:

    PHP Code:
    =MATCH(A4,B7:B25000,1

  2. #2
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    15
    Quote Originally Posted by snb View Post
    Do not consider my suggestions as solutions but as suggestions for a method to attain a certain goal.
    You are free to adapt the suggestions to your wishes/requirements.

    you could simply use this formula:

    PHP Code:
    =MATCH(A4,B7:B25000,1
    Snb thank you anyway for the suggestions, I had already discarded the use of the MATCH formula

    1) Does not find the required value: >=, but choose the previous.
    2) In the case in which the list having two or more dates homogeneous would identify the position of the last value

    I thank all of the suggestions received

Similar Threads

  1. Replies: 4
    Last Post: 04-05-2013, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •