students course

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

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
 
Hi Jimmy,

I assume that the cells are blank if the student has not selected. If so,
you could use Autofilter on the worksheet and for each subject in turn set
the filter to blanks. (Don't set all together; just one at a time.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
how to dispay full course offering while marking what student took 1
Student Database for Course Enrollments 7
Conditional Formatting in a Group on a Report 5
VBA Code; need linked cells to change color if condition met 26
Create Table Query 10
Looking up with more than 1 criteria 5
users and roles 2

Back
Top