How to delete rows

Hello there,


I have a document that contains information about students, such as the student ID, the discipline code and the grades corresponding to a specific discipline. I will attach the document so you guys can better understand it.

The problem is that I need to guarantee that every student has taken all the disciplines. So, what I have to do is to analyse the student ID and check if all discipline's codes corresponds to that student. There is a total of 49 disciplines represented as CD01, CD02, CD03, ..., CD49 (Discipline Code). So, all students must have taken all the 49 courses. If a student has not completed all the courses, say for example, he has completed 48 (or less), I have to delete all the rows that contains informations about that students (we can do that by checking his ID I guess).

The picture below shows a case of a student who has a discipline missing, in this case, the discipline with code equals to CD02. So, this student with ID: 200727040017, must have all the rows (his information) deleted. In the end of the process, only the information of students who have completed all disciplines must remain in the document.

I would really appreciate if you guys could help me in this one. I will also put the document here in case you guys want to use it to work with. If you guys can post the resulting document after solving the problem I'd also appreciate.

Thanks a lot.

Hi Urlant,

I have created a Pivot Table, see attached, which highlights the students who have not achieved the 49 Diciplines.
In addition it also shows the students who achieved 50?
This is as a result of duplications.
Hope this helps.

Regards

peterrc