doris
04-11-2016, 08:44 AM
Hello,
I need help on my Excel Project. It is a grade calculator for students and one of its features is supposed to be generating a timetable based on entered data: course name, days and time when the course is held. This information are stored in an array. I want to create a timetable which displays the course name on the appropriate intersection of day and time (e.g.: Monday and 9:00 am). I have tried with VLOOKUP, INDEX and MATCH and nested IFs but haven't found a solution yet. I would really appreciate any ideas on it.
Thank you in advance :hi:
I need help on my Excel Project. It is a grade calculator for students and one of its features is supposed to be generating a timetable based on entered data: course name, days and time when the course is held. This information are stored in an array. I want to create a timetable which displays the course name on the appropriate intersection of day and time (e.g.: Monday and 9:00 am). I have tried with VLOOKUP, INDEX and MATCH and nested IFs but haven't found a solution yet. I would really appreciate any ideas on it.
Thank you in advance :hi: