• 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. B

    Find first match based on multiple criteria

    Thank you Deb, your formula works like a charm :) About your question "expected result : none" , it's just because my example has only limited datas (7rows), and if the datas are real it could be none(N/A) if the gold price make new high record and then the price go down below that new high...
  2. B

    Find first match based on multiple criteria

    Hi all, I need advise/help to make formula to analyze gold price data. The gold price is going up and down everyday, what I want to analyze: when the gold price is going down in certain date I want my spreadsheet to calculate when the first date the gold price hit the same or higher price and...
Back
Top