Forum Discussion
Need help with tracking students completion of courses
Excel Create a list of folks that have taken courses I have a list of students that have taken several different courses each. There are several courses for each student, I have created how the sp...
bobbloggs74747474b-202 I think your format is a bit odd. Basically I would at least make columns A & B the list of students and classes and then Col C the list of students you need to track followed by your checkmark list.
I didn't do it, but you could also auto-generate the list of all unique students from the list using the UNIQUE() function.
Based on the format you have you can use this array function to generate the entire grid of checkmarks (just past in cell D2):
=IF(COUNTIFS($B:$B,$A2:$A5,$C:$C,D$1:G$1),"√","Record Unavailable")if you don't have array functions then you can use this formula (in D2) and copy/fill down and to the right:
=IF(COUNTIFS($B:$B,$A2,$C:$C,D$1),"√","Record Unavailable")the array function version is attached