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

    Index Match Strategy with Multiple Criteria

    Hello - I am trying to use index match to locate values based on two criteria. The column I want to return is return. I need to match this to a specific date, a fund name and a currency. Thus, there are three different criteria that needs to be met in order to match the right data. Here is...
  2. M

    VBA Code to Indentify Weekdays and Weekends

    Hello - I would like to use a VBA that generates a "true" when a date falls on a weekend and a "false" signal if it is a weekday. I tried some of the codes listed online but none seemed to work properly. Any thoughts?
  3. M

    Need help finding the MAX and MIN for selected groups.

    I need to find the MAX and MIN of the "last" column for the "groups" I created (see table below). The groups are rounded down to 10 minute intervals and then concatenated with the hour and minute. As such, the first group is 12:00am (00) and the third group is 12:14 (rounded down to 12:10am)...
Back
Top