How do I show list of students names who failed on a separate sheet.

It would be helpful if you posted your spreadsheet showing your expected results. In this manner, we can offer up a viable solution.

Thanks for your quick response, I'm just new to this forum and didn't know that I can attach files here. Now I know

Here is the excel file I'm working on, its almost done, I just want to add the last sheet "List of failed students", I dont know how to make it automatically list down failed student. It should be able to check from a list of 47 students from the first sheet "FINAL GRADES", and AUTOMATICALLY show ONLY those who failed on the last sheet (e.g. Student # 4, Student# 14, Student# 21 & Student# 32) and also get the breakdown of their grades (e.g. concept1. concept2 & concept3) and then their final grades.

NOTE:
Attachment from this post already removed (file was corrupted)

Kindly re-attach the file.

I think it's corrupted.

Thank you.

Hi!

Please see attached (Sheet2).


What I did was:

Make an extra column "Status" in the Final Grades sheet.

Please Login or Register  to view this content.

Sort >> Sort Z to A >> Expand the Selection

If you are not familiar with macros, i suggest that you use the sort & filter option. Not unless if anyone here can provide the code for that.

@dongopi77

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.