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

    Index + Match Help

    Aha, that was it. Works perfectly now! Thanks so much for all your help. Much appreciated. :)
  2. C

    Index + Match Help

    Hui Thanks for the help. It doesn't seem to give the results I'm after, though: cells H3-M3 give 0, 1, 1, 2, 3, 4. The only numbers returned should be 1 and 0. I have defined the named ranges you list, and formatted the time cells as hh:mm. Is there something silly I'm missing? (quite possible)
  3. C

    Index + Match Help

    Ah yeah, that might help! A sample data file is here: http://www.speedyshare.com/files/25045954/Timetable_File.xls The source data is on the left hand side of the sheet, and the table I want to populate is on the right. I have left an attempted formula in cell H3. Each row of the source data...
  4. C

    Index + Match Help

    Hi all, sorry if this has already been answered elsewhere. I have 4 columns of timetable data: room number, weekday, start time, end time. I have a separate table with weekday across the top row, hour slot (09:00, 10:00, 11:00...) on the next row and the list of room numbers in a column down...
Back
Top