The scenario is that I am teaching an online class that requires 4 homework submissions per semester with a final exam. I need help to easily find if a student turned in a piece of homework after their final exam.
In the attachment you will see that student 2's final exam was on 09/25/2014 and they turned in a piece of homework on 10/16/2014. I have highlighted this in the attachment, but I was wondering if there was a code to easily highlight or create a chart to pull out only the outstanding dates for every student all at once?
I used the example on the site below to create a chart that uses an INDEX MATCH formula:
http://thinketg.com/how-to-return-mu...ch-or-vlookup/
The formula works well, but the problem is that you have to manually change the student number each time. This is fine with a few students, but it takes a lot of manual effort when there are hundreds of students.
I am thinking there is a solution using a combination of VLOOKUP, COUNTIF, INDEX, MATCH, but I need guidance.
Please let me know if you are able to help.
Bookmarks