Good day,

Much appreciate if some could help me below.

I have a big excel file with up to 2000 lines , in which there are student
names, semesters, subjects. But law, Math, computering and english are
compulsory courses. Is there a macro available easily to identify which
student dose not choose the compulsory subjects? format is as below

Name semester law art english math engineering nursing
computing

John 1
Mike 1
John 2
....... .....

Thanks & Kind regards
Jimmy