I have attached a sample from aspeadsheet I am working on. The option reply sheet has '1' entered if the student has opted to take this course. On the other subject sheets I would like the names who have opted for that subject to appear. Stuidents can opted for multiple subjects. Any support will be great I have tried Match and Index functions but it is difficult as students can opt for more than one.
Many thanks
Bookmarks