Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
students course
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
students course
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.) -- Regards, OssieMac "Jimmy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add New Students | Excel Discussion (Misc queries) | |||
New site for all IT students | Excel Programming | |||
400 students to grade, so little time... | Excel Discussion (Misc queries) | |||
Students and Courses | Excel Programming | |||
I am trying to set a letter grade for my students, HELP | Excel Worksheet Functions |