Thanks for your reply, it is giving me second last term for some ids. I have attached file and highlighted some of the rows which i desire as output. If student is enrolled throughout or graduated or graduated and enrolled these can be deleted. I am looking for student who did not return with their last term's cumulative gpa. I have attached my worksheet.
... View more